Avi
execute is a sqlplus command, not a sql one. You'll need to wrap any procedure calls
in an anonymous block.
eg replace
EXECUTE DBMS_OUTPUT.PUT_LINE('phooo')
with
BEGIN
DBMS_OUTPUT.PUT_LINE('phooo');
END;
Dan
-------------------------------------------------------------------------------------------------------------------------------------
Hello
I'm trying to execute an PL/SQL procedure from an Oraperl script, but i get the
following error :
for example :
....
&ora_do($unm1_lda,"EXECUTE DBMS_OUTPUT.PUT_LINE('phooo')");
....
ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute)
Regards,
Avi Veinshtein
Oracle DBA
www.telrad.com
-----Original Message-----
From: Avi Vainshtein [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 3:11 AM
To: [EMAIL PROTECTED]
Subject: is it possible to execute a package.procedure from Oraperl.pm script ?
<< File: ATT00010.txt; charset = windows-1255 >> << File: ATT00011.html; charset =
windows-1255 >> << File: smime.p7s >>
