Re: Problem with executing Oracle query for creating procedure
| From: | Christopher Jones | Date: | Sat, 28 Oct 2006 00:24:22 +0000 |
| Subject: | Re: Problem with executing Oracle query for creating procedure | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42612@lists.php.net to get a copy of this message | ||
Rosen wrote:
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, RosenNormally I'd use a tool such as SQL Developer or SQL*Plus to pre-create database resident things like tables and PL/SQL procedures. However, back to your problem: use UNIX style end of line characters. Or build up the statement using PHP string concatenation. Chris -- Christopher Jones, Oracle Email: Christopher.Jones@oracle.com Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/