Home » SQL & PL/SQL » SQL & PL/SQL » plsql-reg
plsql-reg [message #37119] Fri, 18 January 2002 20:02 Go to next message
Nantha
Messages: 4
Registered: December 2001
Junior Member
Hi all,

I am Nantha from Chennai,India.

I have one doubt in plsql program. Is there any possibility to use the DDL statements inside the body of the program?.

Please give me answer.

Thanks in advance
Re: plsql-reg [message #37127 is a reply to message #37119] Sat, 19 January 2002 08:25 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
yes, you have to use dynamic sql for that
ex:

create or replace procedure p1 is

begin

execute immediate 'create table xyz(x number)';
end;
Re: plsql-reg [message #37155 is a reply to message #37119] Mon, 21 January 2002 18:38 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Hi nantha
This is Satish From Pune,India .
Now if you are using lower than 8i you need to use DBMS_SQL for executing DDL in subprograms and for Oracle 8i and above , Suresh has given you the answer .
Cya
Previous Topic: Re: how to pass parameters dynamically
Next Topic: Form gets Locked
Goto Forum:
  


Current Time: Fri Jul 23 11:36:40 CDT 2021