Problem with Oracle
| From: | Rosen | Date: | Mon, 23 Oct 2006 23:21:24 +0000 |
| Subject: | Problem with Oracle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42587@lists.php.net to get a copy of this message | ||
Hi,
I have a problem with PHP and Oracle 10 Database.
I read sql script from file and execute it.
Files are something like this:
insert into pts (pid, txt) values (1,'502a');
insert into pts (pid, txt) values (2,'502b');
.....
I receive a message: "ORA-00911: invalid character"
When I remove manually the ";" from the end of every row and execute
separate every command
everything is ok.
I have and script files fo creating procedures/functions and there in not a
problem with ";".
Where is the problem ? Why can not be used ";" as command separator from PHP
?
Thanks in advance!
Rosen