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
PROTECTED]
07/11/2002 09:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Why DDL is not allowed in PL/SQL
Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done
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,