| plsql-reg [message #37119] |
Fri, 18 January 2002 20:02  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
