错误:ORA-00911:无效的角色有人可以帮忙吗? [英] error : ORA-00911:Invalid character can anyone helpout?
本文介绍了错误:ORA-00911:无效的角色有人可以帮忙吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
strb.Append( INSERT INTO PR_JOB_APP_STATUS_DET& _
(ID,PR_JOB_APP_STATUS_ID,PR_EMPLOYEE_MASTER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,EMAIL_ID, & _
Mobile_No,FILE_PATH,JOB_APP_STATUS,STATUS_DATE,REMARKS)& _
VALUES(& _
Trim(t_Id)& < span class =code-string> ,& _
(hdnJobStatID.Value)& ,& _
Trim(t_EmpMasterID)& ,'& _
修剪(t_First_Name)& ','& _
修剪(t_Middle_Name)& ','& _
修剪(t_Last_Name)& ','& _
修剪(t_Email)& ','& _
修剪(t_Mobile_No)& ','& _
修剪(t_File_Path)& ','& _
修剪(RadISR.SelectedValue)& ',& _
RsmartUtl.UDSysDate()& ,'& _
修剪(txtRemarks.Text)& '& );)
如果 strb.ToString<> BEGIN 然后
' strb.Append(END;)
MyCmd.Transaction = MyTrans
MyCmd.CommandText = strb.ToString
MyConn = 新 OleDbConnection( User Id = erponnet; Password = erponnet; Data Source = RSMARTDEVDB; Provider = OraOLEDB.Oracle)
MyConn.Open()
MyCmd.Connection = MyConn
MyCmd.ExecuteNonQuery()
MyConn.Close()
' MyCmd =新的OleDbCommand(strb.ToString(),MyConn)
' MyCmd.Transaction = MyTrans
' MyCmd.ExecuteNonQuery()
' MyTrans.Commit()
结束 如果
解决方案
删除;在SQL语句的末尾
看看这里:
ORA-00911:无效字符 [ ^ ]
ORA- 00911:无效字符 [ ^ ]
strb.Append(" INSERT INTO PR_JOB_APP_STATUS_DET " & _
" (ID,PR_JOB_APP_STATUS_ID,PR_EMPLOYEE_MASTER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,EMAIL_ID, " & _
" Mobile_No,FILE_PATH,JOB_APP_STATUS,STATUS_DATE,REMARKS) " & _
" VALUES ( " & _
Trim(t_Id) & "," & _
(hdnJobStatID.Value) & "," & _
Trim(t_EmpMasterID) & ",'" & _
Trim(t_First_Name) & "','" & _
Trim(t_Middle_Name) & "','" & _
Trim(t_Last_Name) & "','" & _
Trim(t_Email) & "','" & _
Trim(t_Mobile_No) & "','" & _
Trim(t_File_Path) & "','" & _
Trim(RadISR.SelectedValue) & "'," & _
RsmartUtl.UDSysDate() & ",'" & _
Trim(txtRemarks.Text) & "'" & "); ")
If strb.ToString <> "BEGIN" Then
'strb.Append(" END; ")
MyCmd.Transaction = MyTrans
MyCmd.CommandText = strb.ToString
MyConn = New OleDbConnection("User Id=erponnet;Password=erponnet;Data Source=RSMARTDEVDB;Provider=OraOLEDB.Oracle")
MyConn.Open()
MyCmd.Connection = MyConn
MyCmd.ExecuteNonQuery()
MyConn.Close()
'MyCmd = New OleDbCommand(strb.ToString(), MyConn)
'MyCmd.Transaction = MyTrans
'MyCmd.ExecuteNonQuery()
'MyTrans.Commit()
End If
解决方案
Remove the ; at the end of the SQL statement
Have a look here:
ORA-00911: invalid character [^]
ORA-00911: invalid character[^]
这篇关于错误:ORA-00911:无效的角色有人可以帮忙吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文