Execute Multiple Update Statements in Oracle w/C#

[VBRookie]

Hi,

I'm write a class to update data in a oracle database. I want to run multiple statements and from my understanding I can do that by just adding a semi-colon to the end of each statement.

But it appears that oracle also likes for there to be a carriage return following that semi-colon. So how do I add a carraige return to the sql string that I'm executing?

If I use /r or /n it just gets sent as part of the sql statement string and Oracle gives me an error. How do I append an actual carraige return?

Thanks in advance,
- VB Rookie

 

[Cagliostro]

Could you say what are you using to access Oracle?
(I mean one or ADO/DAO/OO4O/OleDB/ODBC)

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com

 

[VBRookie]

ADO.NET ...

I found a post that says Oracle doesn't support executing multiple statements using the semicolon outside of SQLPlus. I was getting an invalid character error until I removed the semicolon from my sql statements.

I therefore modified my class to perform a loop and execute each statement individually. Its not really the way I wanted to do it ... but it works.

Thanks,
- VBRookie