Re: How do oracle programmers send batches of SQL from inside a program?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Fri, 19 Mar 2010 14:55:12 -0700 (PDT)
Message-ID: <62c1affd-189d-4a8f-8c6d-018bb6c0d3b7_at_j21g2000yqh.googlegroups.com>
On Mar 19, 4:34 pm, Thomas Gagne <tgga..._at_gmail.com> wrote:
Date: Fri, 19 Mar 2010 14:55:12 -0700 (PDT)
Message-ID: <62c1affd-189d-4a8f-8c6d-018bb6c0d3b7_at_j21g2000yqh.googlegroups.com>
On Mar 19, 4:34 pm, Thomas Gagne <tgga..._at_gmail.com> wrote:
snip
> If inside a program I want to send multiple SQL statements inside a
> single batch, how is this done inside a program?
>
> I'm using .Net and OracleDataAdapter to submit an OracleCommand.
> Whenever I try to send multiple select statements I get an error
> complaining the SELECT needs an INTO clause, or if I try multiple
> TRUNCATE statements I get an error complaining about a missing option.
>
> I've tried using semicolons and forward slashes, but no luck.
Do as much work as you can in a single SQL statement.
Multiple sql statements in a batch? Why would you want to do that in oracle? Received on Fri Mar 19 2010 - 16:55:12 CDT