Re: simple Stored procedure with drop, create table instruction...???

Hy Fred

In order to use DDL statements inside a stored procedure you must use the DBMS_SQL package.

Ciao

fred wrote:

> I'd like to create a stored procedure looking like that:
>
> CREATE PROCEDURE provToOper
> AS BEGIN
>
> DROP sequence fs_ssis2_oper.COMPANY_SEQ;
> CREATE TABLE fs_ssis2_oper.COMPANY AS (SELECT * FROM fs_ssis2_prov.COMPANY);
>
> END;
>
> But i always get an error message:
>
> PLS-00103: Encountered the symbol "DROP" when expecting one of the foll...
>
> (could not read what it is expecting... It would have been to easy ;-))
>
> Any Idea??
Received on Thu Jul 01 1999 - 09:26:31 CDT