Re: Question about Stored Procedures

From: <sergey_s_at_my-deja.com>
Date: Fri, 18 Aug 2000 00:27:29 GMT
Message-ID: <8nhvt0$73t$1@nnrp1.deja.com>

Use DBMS_SQL package. If you search on dbms_sql in this NG you'll get some nice examples. And it's also described in on-line docs.

Sergey

In article <8ngjm8$gmr$1_at_unbe.sarenet.es>, "Jon" <jzuazoa_at_nexo.es> wrote:
> I need to create an Oracle Stored Procedure that does the following
tasks:
> 1.- Creates a table
> 2.- Make some processing with the data and populate the table created
before
> 3.- Drop that table
> As far as I know, you cannot use DDL with an Stored Procedure in
Oracle. So
> anyone knows which is the best way to accomplish this task?
>
> Thanks
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 17 2000 - 19:27:29 CDT