Home Inserting an OracleClob array
Reply: 0

Inserting an OracleClob array

user1023
1#
user1023 Published in June 20, 2018, 7:27 am

For my .NET project i really need to be able to insert an array of Clob's into an Oracle Db, using the Oracle.ManagedDataAccess lib.

byte[] newval = System.Text.Encoding.Unicode.GetBytes("Testyy");
                    var clob = new OracleClob(connection);
                    var clobList = new List<OracleClob>() { clob, clob };
                    clob.Write(newval, 0, newval.Length);

                    var longText = new OracleParameter
                    {
                        ParameterName = "p_tc_long_text",
                        OracleDbType = OracleDbType.Clob,
                        CollectionType = OracleCollectionType.PLSQLAssociativeArray,
                        Value = clobList.ToArray(),
                        Size = clobList.Count,
                    };

                    command.Parameters.Add(longText);

After execution of the command i get the Oracle Error:

ORA-03120: two-task conversion routine: integer overflow.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.306402 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO