Recent content by diesel

The reason I changed the function column to CLOB is because of the limitation of the varchar2 to 4000 characters. Even if I cast the output it will only return max of 4000 characters right? A normal "select function from tasks" works fine. The problem is that when I try to concatenate the...

Hi I am trying to create a script to use to populate a "new database" with the existing database table data. The problem is the table has a clob column and I am experiencing problems. Here is the sql command that worked before I changed the column(Function) in the table to clob. select...

Thanks for the reply I am still not sure how to do this. My table is TASKS, clob column is "FUNCTION" My Oracle Session is m_GlobalOracleSession. int otClob; TLOBLocator *LOB = new TLOBLocator(m_GlobalOracleSession, otCLOB, true); I am still not sure how one could use this LOB value to insert...

Hi I have a CLOB column and I need to use C++ builder to pass a very long string to a stored proc.The stored proc takes in the long string and should store it to the clob column. It works without raising any errors but only stores about 4000 characters of my 30000 or so. I am not allowed to use...