Yes, But why then we can issue DLL in PL/SQL using
DBMS_SQL package.
-Original Message-
From: Alroy Mascranghe [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Why DDL is not allowed in PL/SQL
Maybe
You can also use execute immediate in PL/SQL, depending on the version of
Oracle you are running.
RF
Robert G. Freeman - Oracle8i OCP
Oracle Database Architect
CSX Midtier Database Administration
Author:
Oracle9i RMAN Backup and Recovery (NEW! Oracle Press - Due Oct 2002!!)
Oracle9i New
I would guess because it's not part of PL/SQL.
The DBMS_SQL package and 'EXECUTE IMMEDIATE' both send
your SQL to the database engine.
You may recall the the engine running PL/SQL is separate from the
DBMS engine, at least through 8i.
Jared
sam d [EMAIL PROTECTED]
Sent by: [EMAIL
Sam,
If u r in 8i and above
You could use
execute immediate 'create table .';
Regards
Suhen
Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
__
Do
Maybe it is to maintain transaction consistency, bcos the DDLs issue a
commit implicitly. So if u do in the middle of DML-transaction it might mess
up the transaction as a whole.
-Original Message-
Sent: Friday, July 12, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L
Hi List,
