To clarify: Of course, the only thing that executes correctly under SQLplus of those 3 lines is the "EXECUTE Upd_lead_time" statement.
:-) -----Original Message----- From: Laurie Vien [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 1:02 PM To: '[EMAIL PROTECTED]' Subject: Syntax for executing a stored procedure? I'm using DBI::ODBC. All I want to do is execute a stored procedure, but the 3 lines below (which execute correctly under SQLplus) result in an "invalid SQL statement" error. (My ODBC connection is set up to use the Microsoft ODBC Driver for Oracle.) What would correct syntax be?: $sql_stmt = "EXECUTE Upd_lead_time"; $sth = $dbh->prepare($sql_stmt); $sth->execute(); Laurie A. Vien Sr. Programmer/Analyst Ben & Jerry's Homemade, Inc. South Burlington, VT 05403
