OraFAQ Forum: SQL & PL/SQL » DDL Through stored procedures plz. help

Home » SQL & PL/SQL » SQL & PL/SQL » DDL Through stored procedures plz. help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDL Through stored procedures plz. help [message #40273]

Sat, 21 September 2002 06:06

jawadg
Messages: 19
Registered: May 2002

Junior Member

I want to perform DDL operations[[create,alter,drop]] through stored procedures.
i know that packages like dbms_sql,dbms_ddl will be used. Plz. give me a solid example of that with coding
Bye
Waiting for ur. help

Report message to a moderator

Re: DDL Through stored procedures plz. help [message #40284 is a reply to message #40273]

Tue, 24 September 2002 00:38

venkatesh
Messages: 72
Registered: August 2000

Member

hi

why dont u try EXECUTE IMMEDIATE statement for this stuff. try this code to create a table from a procedure

begin
sqlstr:='create table stud(name varchar2(10), age number)';
execute immediate sqlstr;
end;

Report message to a moderator

Re: DDL Through stored procedures plz. help [message #40330 is a reply to message #40284]

Fri, 27 September 2002 18:40

jawadg
Messages: 19
Registered: May 2002

Junior Member

i have applied this code but i m getting errors
like that
'Insufficient Priviliges'
Plz. help me

Report message to a moderator

Previous Topic:	How to insert images into database
Next Topic:	Extracting Number from an Alphanumeric string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 15:30:40 CDT 2024