Re: One SQL statement to update multiple tables?

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 21 Jul 1998 12:25:25 +0100
Message-ID: <6p1tsk$5hn$1@schbbs.mot.com>

OK, I've never seen VB5 or used ODBC to get to Oracle so I may be wide of the mark here but could you not wrap all three update statements into one Oracle PL/SQL block of code and then fire that at the server, all in one go?

--
Alan D. Mills

Chris Garland wrote in message <6p14fo$rac$1_at_nw003t.infi.net>...
>Can anyone think of a solution (i.e., strange and convoluted SQL
>statement, some funky Oracle trick,etc.) that will allow us to execute
>only one ODBC call to update multiple tables?
>
Received on Tue Jul 21 1998 - 06:25:25 CDT