Oracle/VB....can't we all just get along?

From: Steve P <stevep_at_nospamprosoftcorp.com>
Date: 25 May 1999 10:34:57 PDT
Message-ID: <7ien01$da6@journal.concentric.net>

Hi,

Does anyone know how to submit multiple SQL statements to an Oracle database using
SQL created in VB?

For example in SQL Worksheet for Oracle I can successfully submit the following statement:

UPDATE Users Set Name = 'Steve' WHERE User_ID = 1; UPDATE Users Set Name = 'Frank' WHERE User_ID = 2;

and execute both at once. But in VB when I try:

sSql = "UPDATE Users Set Name = 'Steve' WHERE User_ID = 1; " & vbCrLf & "UPDATE Users Set Name = 'Frank' WHERE User_ID = 2;"

I get an Oracle error which says 'invalid character'. I get the same message when using SQL*Plus. Is there any way around this in VB?

Please let me know if you know of a solution.

Thanks a lot,

SP Received on Tue May 25 1999 - 12:34:57 CDT