Go thru this URL, you will find an example of how to execute a stored prcedure using perl
http://www.saturn5.com/~jwb/dbi-examples.html Regards Amarnath.K.Habib Aquila TEchnologies Bangalore India Vu Van Toan wrote: > Hi All, > How to execute a stored procedure in ORACLE using DBD::Oracle? > > pls help me, now i can excute some simple query but i could not execute > my procedure by syntax > $dbh->do("EXEC myprotest('aaa',1)"); > > i get the error in log: > DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR: > OCIStmtExecute) at ... line 137
