Re: Problem with Oracle
| From: | Rosen | Date: | Tue, 24 Oct 2006 10:25:03 +0000 |
| Subject: | Re: Problem with Oracle | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42591@lists.php.net to get a copy of this message | ||
"Chris" <dmagick@gmail.com> wrote in message
news:453D71EF.6090101@gmail.com...
> 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?
>
Do you mean PHP code ?
> --
> Postgresql & php tutorials
> http://www.designmagick.com/