[eluser]edhrx[/eluser]
Hi,
can anyone help me with the syntax for calling an oracle stored procedure.
This snippet wont work
$sql = 'EXEC PREPRINT_CRFS01(40)';
$this->db->query($sql);
[40 is an input parameters]
The log gives me this
ERROR - 2009-05-20 08:23:49 --> Severity: Warning --> ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00900: invalid SQL statement C:\xampp\htdocs\risa\system\database\drivers\oci8\oci8_driver.php 154
best wishes Ed..