clob

[planas]

Hello

This code raise an exception (invalid handle).

var
MonClob_in: TLOBLocator;
begin
MonClob_in := TLOBLocator.Create(orases1, otCLOB);
MonClob_in.AsString:='test';
end;

My problem is i have a procedure in a package that need a string.
I don't use Varchar2 because it's limited to 4096 chars. My string is a XML string.
So i use a clob.

My proc is like :
PROCEDURE P_TEST_CLOB(P_CLOB_IN IN CLOB) IS
BEGIN
NULL;
END;

How i transform my delphi string to this clob ?
Is there is another solution more simple than clob ?

Jean-Pierre

 

[Marco Kalter]

Maybe you can use a PLSQLString or a LONG instead of a String (32KB limit instead of 4KB limit).

The next Direct Oracle Access version supports Temporary LOB's, which can be used like your example. I have a patch available that adds this capability to 3.4, though it requires that you have the source files.

------------------
Marco Kalter
Allround Automations