CLOB in Stored Procedure is not working

Database
Teradata Employee

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.

2 REPLIES
Enthusiast

Re: CLOB in Stored Procedure is not working

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.
Teradata Employee

Re: CLOB in Stored Procedure is not working

My bad - the SP is actually defined as shown, but still produces the error. Hopefully we will get the fix soon.

Thanks

REPLACE PROCEDURE brin_dev.clob_test
(
IN myclob CLOB
)
BEGIN
DECLARE myclob2 CLOB;

END;