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,
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