ORA-02201: sequence not allowed here
Although we try to provide custom solutions, we do not have a solution yet for all Oracle Error Messages. We apologize for that. You can use the feedback part to indicate this was not helpfull and we'll try to prioritize the creation of a satisfying solution.
*Action: A sequence can only be referenced in a select-list.
Welcome to our forum for Oracle error: ORA-02201 Add your own message
Enter your me EmpXmlDoc As New XmlDocument()Dim EmpXmlRootNode As XmlNode = EmpXmlDoc.SelectSingleNode("records")Dim conStr As String = ConfigurationManager.AppSettings("UGCConnection")
Dim
con As New
OracleConnection(conStr)
con.Open()
' Create the command.
Dim cmd As New OracleCommand(""
, con)
' Set the XML command type to insert.
cmd.XmlCommandType = OracleXmlCommandType.Insert
' Set the XML document.
Dim xmlDocText As String
= EmpXmlRootNode.InnerXml
cmd.CommandText = xmlDocText.Trim
' Set the XML save properties.
cmd.XmlSaveProperties.RowTag = "record" cmd.XmlSaveProperties.Table = "EMPTest"
' Do the insert
cmd.ExecuteNonQuery()
I am inserting XML file data into Oracle Table by Using Above code. but it gives me this error " ORA-02201: sequence not allowed here"
Please give me Solution if any one have.
Thanks
ssage
Dim
EmpXmlDoc.Load(Path)
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.