--- Dave K <[EMAIL PROTECTED]> wrote:
> Mark,
> > You can _only_ put DML inside a pl/sql block, not DDL.
> >
> > So your problem was:
> >
> > 1) you tried to put DDL into a pl/sql block (Oracle disallows)
> > 2) you didn't have a valid block (no begin/end;)
>
> Did you try this at all?
> The 'CREATE OR REPLACE...'
> ddl works fine. It's not disallowed by Oracle, DBI etc..
I didn't say DDL was disallowed. I said DDL is _not_ allowed
inside a _plsql block_.
> The issue was multiple statments.
> Please reread the OP.
The "issue" was why weren't multiple statements working, when
the documentation said they would?
The answer is that sometimes multiple statements can work,
and sometimes they can't. I explained the rules before,
but I'll repeat them here, since if you misunderstood my
post and the rules, perhaps the original poster still does
as well:
- multiple DML statements can be executed in a single call
to Oracle, but they must be wrapped in a plsql block, not
simply concatenated together.
- plsql blocks have the structure:
begin
statement ;
statement ;
end;
- DDL can never be executed in a plqsl block.
The original poster's problem was the he had code like this:
"ddl statement;
ddl statement;"
which, as you and he know, doesn't work. Now the simple-minded
response to the problem is just to say that you can't execute
two statements at once. But recall that the poster wasn't
only asking about his code -- he specificially asked why his
problems appeared to contradict the documentation, and he
was very clear that he tentatively concluded the documentation
to be incorrect, and he pleaded:
"I would be grateful for any feedback about preparing and
executing multiple SQL statements using DBD::Oracle"
Hence I provided the complete answer: you can do multiple
sql statemtents (but only DML and in a plsql block).
Hope that clears up your confusion.
Mark
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
