Hi

I'm trying to run multiple inserts in oracle 9i

my statement is like this

insert into y (col1, col2 , col3) values (1,2,3);
insert into y (col1, col2 , col3) values (2,3,4);
insert into y (col1, col2 , col3) values (3,4,5);
insert into y (col1, col2 , col3) values (4,5,6);
commit;

when i send the query to the oracle server I get the error invalid
character (because of the semicolon)
if i remove the semicolon i get the error 'Sql command not properly
ended'

what whould be used to run multiple insert

also is i possible to do multiple select ?

thanks

[MSSQL] [WebService] Last inserted ID in transaction
OrderID or DataTable
Currency Manager
copying an object by value
Multiple relation in dataset.