PB 6.5 and Oracle CLOB object

[cham911]

PB 6.5
ORACLE 8

I need to send the syntax of a complex DW to a stored procedure.
I subclassed the transaction object and defined a local external function wich is a RPCFUNC ALIAS to the stored procedure and defined the argument as a PB string object.

PB compile works fine but at runtime, the sqlcode is -1 and sqlerrtext contains a message ora06550 : identifier for '<name_of_the_storeproc>' must be declared.

I suspect the pb String datatype doesn't match the clob defined in the procedure parameters.

Can somone help me about the matching pb datatype for a oracle clob object ?
Example is greatly welcome.

Thanks for your help

 

[OlanKnight]

If a &quot;CLOB&quot; is a character large object in Oracle, perhaps you should send it a BLOB object from PB? I know that a string has additional data embedded into its structure (like its length) and thus should not be used to contain BLOB-type data.

In PB8, I'd suggest you use GetFullState, but in PB6.5 I'm not sure what you can use. You might try looking at some strings in a low-level tool and determining where the extra data is located. Then you could strip that data from the string and store the remainder into a blob.


Olan