Databases
StackOverflow2013
Postsdbo
POVB.net Oracle Operation is not valid due to the current state of the object
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVB.net Oracle Operation is not valid due to the current state of the object
    primarykey
    data
    text
    <p>Ok, i am really in need of finding a way to do this via a string to clob instead of using the update query to to do all.</p> <pre><code>Dim theXMLCode As OracleClob Dim OracleConnection2 As New OracleConnection() Dim dr2 As OracleDataReader Dim holdXML As String = "" Public Function connectToOracleDB2() As Boolean OracleConnection2.ConnectionString = "User Id=" &amp; dbUserId &amp; ";Password=" &amp; dbPassword &amp; ";Data Source=(DESCRIPTION=(ADDRESS_LIST=" &amp; _ "(ADDRESS=(PROTOCOL=TCP)(HOST=" &amp; dbHost &amp; ")(PORT=" &amp; dbPort &amp; ")))" &amp; _ "(CONNECT_DATA=(SERVICE_NAME=" &amp; dbServiceName &amp; ")))" Try OracleConnection2.Open() Return True Catch ee As Exception OracleConnection2.Close() Return False End Try End Function Dim strSQL = "UPDATE CSR.TARGET ces " &amp; _ "SET (STATUS_CODE, COMPLETE_DATE, DATA) = " &amp; _ "(SELECT 'ERROR', '', (:XML_DATA) " &amp; _ "FROM CSR.SOURCE C " &amp; _ "WHERE (c.EID = ces.EID) " &amp; _ "AND c.STATUS_CODE = 'ERROR') " &amp; _ "WHERE EXISTS (SELECT 1 " &amp; _ "FROM CSR.SOURCE C " &amp; _ "WHERE (c.EID = ces.EID) " &amp; _ "AND c.STATUS_CODE = 'ERROR')" Try Dim parmData As New OracleParameter With parmData .Direction = ParameterDirection.Input .OracleDbType = OracleDbType.Clob .ParameterName = "XML_DATA" .Value = holdXML End With OracleCommand2.Parameters.Add(parmData) OracleCommand2.CommandText = strSQL OracleCommand2.ExecuteNonQuery() </code></pre> <p>But i get the error:</p> <p><strong>ERROR: Operation is not valid due to the current state of the object.</strong></p> <p>On the line:</p> <pre><code>OracleCommand2.ExecuteNonQuery() </code></pre> <p>Any help would be great to get this thing working :o)</p> <p>David</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USStealthRT
    1. USStealthRT
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVB.net Oracle Operation is not valid due to the current state of the object
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs holdXML a temp LOB? See http://msdn.microsoft.com/en-us/library/cydxhzhz(v=vs.80).aspx for working with Oracle BLOBs in .NET
      singulars
      1. POVB.net Oracle Operation is not valid due to the current state of the object
      1. UStawman
    2. COholdXML is a string that was populated from the CLOB (blah.value). I need to find a way to convert it back to a CLOB and insert it into the database again. The link you posted doesn't seem to use CLOB?
      singulars
      1. POVB.net Oracle Operation is not valid due to the current state of the object
      1. USStealthRT
    3. COThere is a CLOB example in the MSDN link. Oracle BLOB/CLOB are pointers, and you cannot update them directly from .NET. Google / Search for the dbms_lob.createtemporary PL/SQL helper.
      singulars
      1. POVB.net Oracle Operation is not valid due to the current state of the object
      1. UStawman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload