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

Steve P <stevep_at_nospamprosoftcorp.com> wrote in message news:7ien01$da6_at_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;"
>

execute them seperately, and remove the ; from the string

> 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 Wed May 26 1999 - 15:05:59 CDT