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:
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):
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!