Re: pl/sql - help!!

From: AlexJent <alexjent_at_aol.com>
Date: 1997/01/31
Message-ID: <19970131010200.UAA12294@ladder01.news.aol.com>#1/1

>>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