Hi All,
I am trying to INSERT a record into a table that contains two CLOBs.
The TOracleQuery contains :-
BEGIN
INSERT INTO <Table>
(
<Col1>,
...
<Col84>
)
VALUES
(
:V_COL1,
...
:V_COL84
)
RETURNING <Col75>,
<Col76>
INTO :V_COL75,
:V_COL76;
END;
In code I then do this :-
LOB1 := TLOBLocator.Create(<Session>, otCLOB);
LOB2 := TLOBLocator.Create(<Session>, otCLOB);
try
InsertRecord.SetVariable('V_COL1', <Value>);
...
InsertRecord.SetComplexVariable('V_COL75', LOB1);
InsertRecord.SetComplexVariable('V_COL76', LOB2);
...
InsertRecord.SetVariable('V_COL84', <Value>);
InsertRecord.Execute;
LOB1.AsString := 'TEST1';
LOB2.AsString := 'TEST2';
finally
LOB1.Free;
LOB2.Free;
end;
On the "InsertRecord.Execute" I then get the following error :-
ORA-01036: illegal variable name/number
I have triple checked all the variable names & types on the TOracleQuery and they all appear correct.
I've been on this for hours now and feel like banging my head against a wall!!!
Please could someone put me out of my misery? :-)
Regards
David