Re: DDL in stored procedures?
From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Wed, 13 May 1998 18:57:57 GMT
Message-ID: <3559ED34.C7A00913_at_access-laserpress.com>
Date: Wed, 13 May 1998 18:57:57 GMT
Message-ID: <3559ED34.C7A00913_at_access-laserpress.com>
Direct DDL is not allowed in PL/SQL, you must use the DBMS_SQL package to execute "dynamic" SQL.
Yakov Fain wrote:
>
> Hello,
>
> I was trying to create a table (using CREATE TABLE statement) from
> oracle's stored porcedure but it wold not compile. Is this illegal in
> Oracle? In Sybase it works just fine.
>
> Thank you,
>
> Yakov Fain
Received on Wed May 13 1998 - 20:57:57 CEST