Thank you all for responding! I tried Chris' suggestion since my clob is defined as an output parameter in my stored procedure.
The stored procedure finally compiled but I now am receiving an error mesage while executing it
ORA-06502 PL/SQL numeric or value error invalid LOB locator...
Hello,
I am writing a stored procedure which will create a large amount of data to be sent to MQSERIES. My stored procedure obtains data from our tables and creates the string. I have tried to do the following and I receive an error (PLS-00382: expression is of wrong type).
p_buffer :=...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.