Procedure error / Oracle / ODBC

[Anon]

Hi,
Does anyone know the reason for the following error message:

---

Warning: SQL error: [Oracle][ODBC]Syntax error or access violation., SQL state 37000 in SQLExecDirect in e:\oracle\ora90\apache\apache\htdocs\mercalli\functions.inc on line 91

---

where line 91 is like:

---

$ResultId = odbc_exec ($global_dbh, "execute proc_reikna_mercalli_stig (163)");

---

I´m trying to execute a procedure on a Oracle 9i database from PHP.
The procedure is correct since it workes fine if I call it from SQLPlus.

With regards and thanx in advance, Erlendur

[Anon]

Execute is not an SQL statement. At least not for Oracle anyways. It is actually a SQL*Plus command. Instead try encapsulating your procedure call in a begin/end block.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com