I have a batch of sql statements such as ...
insert into.... ; insert into.... ; delete .........;
etc
When i try to execute them against oracle it gives me this error (ORA-00911 Invalid Character)
now i can understand that this is because of the semicolon between the statements, i tried this on SQL Server and it worked but in Oracle no luck so far.
Is there a way to run multiple statements against oracle by using the ExecuteScalar or some other function?
DUPLICATE: How can I execute multiple Oracle SQL statements with .NET
Try wrapping with a BEGIN..END
BEGIN insert into.... ; insert into.... ; delete .........; END;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With