Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: "Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO: ORA-24344: success with compilation error in..." And the procedue doesn't put in the database. When I edit the .sql file - all to be on 1 row - like this: "create or replace procedure test_proc1(p1 IN number, p2 OUT number) as begin p2 := p1 + 10; end;" Then I have no problems. Can someone help me with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
