Re: Executing SQL via MDAC ODBC multiple statements?

ackthpt_at_concentric.net (Richard Adams) wrote in message news:<c2352af0.0401091510.9904358_at_posting.google.com>...
> Is it possible to execute more than one statement in SQL via MDAC
> ODBC? I have a fairly complex select I wanted to create a view with,
> but trying to send it all as one string with terminators ';' between
> doesn't work (invalid character.) How can I do this kind of thing
> from VB.NET?

You can only execute one PL/SQL block at a time in Oracle. You may be able to combine a number of statements into a single anonymous PL/SQL block, though-- i.e.

declare
  <<list of variables>>
begin

  SQL Statement 1;
  SQL Statement 2;
  SQL Statement 3;

When you start wanting to do this sort of thing from a client application, however, I would strongly recommend writing a stored procedure that does whatever you want to do and calling that stored procedure from the client.

Justin Cave
Distributed Database Consulting, Inc.
www.ddbcinc.com/askDDBC Received on Sat Jan 10 2004 - 09:16:37 CET