oracle update2¸ö±äÁ¿Ôõôд? - Oracle / ·Ç¼¼ÊõÇø

<%
If Request.Form("mySubmit") = "Modify" Then 
total = i
for i=1 to total
rbb = Request.Form("rbb"& i )
guanxz=Request.Form("guanzx"& i )
names=Request.Form("names"& i)
strSql="Update code_tank Set rbb="& rbb &" where names='"+names+"' "
'strSql="Update code_tank set rbb='"&rbb&"',guanxz='"+guanxz+"' where names='"+names+"' "  
conn.execute(strSql)
Next
response.redirect Request.ServerVariables("HTTP_REFERER")
conn.close 
Set conn = nothing 
End If
End If 
%>
µÚÒ»¸östrSqlÄÜÖ´Ðгɹ¦,µÚ¶þ¸ö²»ÄÜÖ´ÐгöÏÖ´íÎó:
Microsoft OLE DB Provider for Oracle ´íÎó '80004005' 

ORA-01407: cannot update ("GUANXZ") to NULL 

---

conn.execute(strSql)
ÄãÔÚÕâ¸öÇ°Ãæ¼Ó¾ä»°,SYSTEM.PRINTLN(guanxz);°ÑGUANXZµÄÖµ´òÓ¡³öÀ´¿´¿´
Ìáʾ˵ÄãµÄÊÇ¿ÕÖµ

---

ÒÔÏÂÊÇÈ«´úÂë,guanxzµÄÄÚÈÝÒѾ­ÏÔʾÀ²Ñ½!
<form name="form" method="post" action="">
<%  
 Set conn=Server.CreateObject("ADODB.CONNECTION")  
  HJSTRCONN="Provider=MSDAORA;Data ......."
 conn.Open HjStrConn  
  guan1="A103"
  guan2="A104"