Re: Place SQL statements in PL/SQL procedure but failed...

Hi David,

    Since u are using Oracle 7.3.3, u cannot just put DDL (Data Definition Language) statements in a procedure.

Infact, only in Oracle 8.0 & later, is there a way of putting DDL statements in proecdure w/o much hassles.

Since create table,drop table etc are DDL commands, u need to use dynamic SQL for the same. The buuilt-in pl/sql package:DBMS_SQL has functions/procedures to acheive this.

    The way of doing this is pretty simple and should be documented in any good PL/SQL book.

Hope that helps.

Regards,
--Vishal

laulau823_at_my-deja.com wrote:

> Hello all,
>
> I create the following procedure:
>
> create or replace procedure testing as
> begin
> create table a as ...
> create view b as ...
> truncate table c;
> drop table c;
> end;
>
> However, there is something wrong in compilation.
>
> How can I place the above SQL statements in PL/SQL procedure such
> that when I execute this procedure, the above SQL statements will be
> executed?
>
> I am using Oracle 7.3.3.
>
> Thanks,
> David
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 11 2000 - 01:33:36 CET