oci_execute and package executing problem

[Flyzone]

Hi,
i'm trying to execute a package from php with oci_execute.
The package works perfectly from sqlplus, but the same string give me
this result:
"ORA-00900: invalid SQL statement"

The string executed is:
$query="execute
ddl_actions.cas cade_update('TA BLE','COLUMN',' $oldvalue','$ne value')";
$package_query = oci_parse($db,$ query);
$r=oci_execute( $package_query) ;

And also, oci_statement_t ype($package_qu ery) give me as result:
UNKNOW.

What is wrong in the call? All the other query works also in php with
oci_execute, but the call of a package not.

Hope someone could help me.
Thanks in advance.

[Flyzone]

Re: oci_execute and package executing problem

On 10 Mar, 12:18, Flyzone <flyz...@techno logist.comwrote :

"ORA-00900: invalid SQL statement"

Solved by my DBA, the exec cannot be called like in sqlplus, but with:
$query="BEGIN
ddl_actions.cas cade_update('TA BLE','COLUMN',' $oldvalue','$ne wvalue');
END;";