Problem with executing Oracle query for creating procedure
| From: | Rosen | Date: | Fri, 27 Oct 2006 15:21:58 +0000 |
| Subject: | Problem with executing Oracle query for creating procedure | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42609@lists.php.net to get a copy of this message | ||
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