I see lots of examples using Delphi but non for C++ Builder with the temporary LOB (CreateTemporary) calls.

I don't even know if that's what I need to do....

I have an Oracle function inside a package:
SQL Query
function my_func(pJSON in clob) returning clob is
  cRetval clob := empty_clob();
begin
  cRetval := 'some long text value in JSON format';
  return cRetval;
end;

I use the Package Wizard to create components for each of my packages.

I want to call this function from C++ Builder, passing in a CLOB and receiving a CLOB in return.

Code that was working (but not with 11.3):
Code

TLOBLocator *inp = new TLOBLocator(OraSession, otCLOB, true);
inp->AsString = "some JSON input string";

TLOBLocator *outp = MyPackage->MyFunc(inp);      // <<- crash here
ShowMessage(outp->AsString);

delete outp;
delete inp;

Any help (with examples) would be greatly appreciated!

Last edited by Stephen; 08/11/23 04:12 AM.