|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 4:01:17 PM
Posts: 91,
Visits: 118
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 7:10:35 PM
Posts: 224,
Visits: 527
|
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 4:01:17 PM
Posts: 91,
Visits: 118
|
|
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;
|
|
|
|