I'm not sure.. but try the folowing statements:
$sql = "INSERT INTO tblTest VALUES(1,'Test One') INSERT INTO tblTest
VALUES(2,'Test Two') INSERT INTO tblTest VALUES(3,'Test Three') ";
(just repeating the insert statement... )
or
(repeating the insert statement, separated by semicolon...)
$sql = "INSERT INTO tblTest VALUES(1,'Test One'); INSERT INTO tblTest
VALUES(2,'Test Two'); INSERT INTO tblTest VALUES(3,'Test Three'); ";
Chris Andrew wrote:
> Hi,
>
> This is probably more of a topic for the Oracle groups - however:
>
> This gives me an error:
> $c1 = ocilogon("chris","chris01");
> $sql = "INSERT INTO tblTest VALUES(1,'Test One'),(2,'Test Two')";
> $stat= ociparse($c1,$sql);
>
> It would appear my INSERT syntax is illegal under Oracle.
>
> Qu: How can I INSERT multiple rows with ONE statement?
>
> Thanks in advance.
> Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
