ORACLE Stored Procedures via ODBC

[Anon]

Is possible to execute a Stored Procedure in Oracle using ODBC?

I tried something like that,

// $conn is my connection
$query = "exec storedprocedure"
odbc_exec($conn, $query);

But always I receive an error like "Syntax Error o Permission Error" [I don't remember the exact phrase]

When I copy the output of:

echo $query;

into an SQLPlus terminal the Stored Procedure works fine with the same Username, Password and DB.

Can I execute an stored procedure via ODBC??

I'm using
PHP4
WINDOWS 2K ADVANCE SERVER
ORACLE

PLease, forgive my poor english.

[Anon]

It seems to be a Permission Error.

Validate grant privileges for your webserver to execute the SP. PHP resides in the webserver.
Maybe there is another user to set.

Finally SQLPlus is allow to execute. Perhaps this explains the "paradoxon"

You can test it with phpOra(cle)Admin from freshmeat.net.