Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql - help!!
>>How do I issue a create table stmt w/in a PL/SQL block in a stored proc
>>implementation. The syntax for my create table is fine-- it goes
>>smoothly when entered at SQLPLUS command line. Same command w/in s
You cannot do what you are attempting... The CREATE statement is a DDL (data dfinition language) statement which is not allowed(directly) in PL/SQL. If you really need to do this... You'll have to use the DBMS.SQL package to get it done.
Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com
E-Mail Work: jentilucci_at_notes.seagate.com
Home: AlexJent_at_aol.com Received on Fri Jan 31 1997 - 00:00:00 CST