Executing Oracle store procedure via ODBC

[Roditek]

Hello all,

I'm trying to execute an Oracle store procedure via an ODBC driver from PHP 4.

The store procedure works just fine by itself. But it seams that I am not using the proper syntax to execute it via the ODBC.

Here is my piece of code:

$odbc = odbc_connect ("ODBC driver name", "user", "passwd");
$res = odbc_prepare($odbc, "execute sp_add_type('abc')");
odbc_execute($res);

and here is the error that I am receiving:

Warning: SQL error: [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement , SQL state 37000 in SQLExecute in c:\php\abc.php on line 210

Anyone can help with this?

Thank you in advance 🙂

[YappyDog]

Instead of

$res = odbc_prepare($odbc, "execute sp_add_type('abc')");

Try:

$res = odbc_prepare($odbc, "begin sp_add_type('abc'); end;");

[Roditek]

Thank you YappyDog,

Your suggestion works perfectly.