Delphi ADO sql statement for inserting a CLOB into Oracle 8/9
Posted on 2004-10-22
I have an application that needs to insert a record into a table which includes a CLOB field. I've seen comments about dbms_log and about empty_clob(), but would really appreciate someone who's done this to put together a couple of sql statements that I can execute to get the job done.
I have a TMemo control on screen (not data bound) and I need to pass the text over and get it inserted into the table. What I've tried so far is
ADOCmd.SQL := 'Insert into Memos (Recno, Notes) values (1234, ' + moDescrip.Text + ')';
For someone who's done this before, this should be quick and easy points. :-)