Re: Stored Procedure Question

On Wed, 13 May 1998 13:13:58 -0400, "Jennifer Caudullo" <jennifer_caudullo_at_acwins.com> wrote:

>I am creating a package that one of the procedures within needs a temp
>table. As far as I am aware you cannot create a temp table in Oracle. If I
>am wrong, please let me know. So what I did was within my package, I
>created a table, inserted into it and then updated it and then dropped it.
>Here is the code. Could you please tell me what is wrong with it? My email
>is jennifer_caudullo_at_acwins.com
>
>Thank you. I appreciate it.
>
>CREATE TABLE IBNR.TEMP
>(
>ACCIDENT_YEAR_GROUP NUMBER NOT NULL,
>SELECT_ARM NUMBER NOT NULL,
[...]

Hi Jennifer,

if you want to issue DDL statements in PL/SQL, you can only do so by using the DBMS_SQL package.

HTH,
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net