Is dbms_output.put_line invalid SQL statement??!!

From: Peter <piterek9_at_poczta.onet.pl>
Date: 16 Jan 2003 12:21:16 -0800
Message-ID: <aaf8f6e6.0301161221.1935bb95_at_posting.google.com>



Hi,

I tried use my function (defined in a package) using EXEC SQL CALL in Pro*C (Ora 8.0.6 / 8.1.5)
I always got "ORA-00900: invalid SQL statement".

To check what is wrong I tried to use well-known procedure:

EXEC SQL CALL dbms_output.put_line('xxx');

or

strcpy(ptn,"xxx");
EXEC SQL CALL dbms_output.put_line(:ptn);

Results were the same - ORA-00900.

Everything is correct according to Pro*C documentation. I compiled it with check=semnatics and connecting to database during compilation (userid).

It seems that all function names after "CALL" are refused. DBMS_OUTPUT.PUT_LINE procedure also!
Do you know what is wrong?

Thanks in advance,
Peter Received on Thu Jan 16 2003 - 21:21:16 CET

Original text of this message