All Forums Database
j355ga 100 posts Joined 12/05
24 May 2006
CLOB in Stored Procedure is not working

Anyone run into this yet? I can't find any information on this. The documentation claims that CLOB is supported in SP.REPLACE PROCEDURE clob_test(IN myclob CLOB)BEGIN DECLARE myclob CLOB; END; BTEQ -- Enter your DBC/SQL request or BTEQ command: call clob_test('foo');call clob_test('foo'); *** Failure 2646 clob_test:No more spool space in All. *** Total elapsed time was 1 second.

Jeff
Jim Chapman 449 posts Joined 09/04
25 May 2006

Evidently, it should have failed to compile due to the duplicate definition of "myclob". This appears to have been fixed recently, but I don't know which release has the fix.

j355ga 100 posts Joined 12/05
25 May 2006

My bad - the SP is actually defined as shown, but still produces the error. Hopefully we will get the fix soon. ThanksREPLACE PROCEDURE brin_dev.clob_test(IN myclob CLOB)BEGINDECLARE myclob2 CLOB;END;

Jeff

You must sign in to leave a comment.