Rosen wrote:
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 ";".
Then you're not showing us the exact content of the files or the code
you're using to make this insert into your database.
What's the exact code you're using to go through the file and insert the
data?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
