CLOB field with TOracleQuery

[mhajduk]

Tying to set a paradox memo field to a CLOB field and having troubles. when inserting a new row assigning the value using;

oraclequery.setvariable('Notes',paradoxtable.fieldbyname('notes').value);

get error exception Pass Longint(object) to complex variable 'NOTES'.

How to you set the clob.

thanks
Mike

 

[Marco Kalter]

For a CLOB variable you need to assign a TLOBLocator instance and pass the actual data after inserting the record. See this topic for an example.

 

[mhajduk]

Thanks, I have added the Tloblocator process to the insert but the clob data is always blank. In the example you use a stored procedure. Do you have to have the stored procedure or can you just execute the query and add the data to the clob throught the Tloblocator.

 

[mhajduk]

Thanks I have solved the problem, I had to insert with empty_clob() for the value before I assigned the value to the locator.