RE: Dropping & re-Creating Sequences in PL/SQL

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Wed, 28 Jun 2000 11:15:39 -0300
Message-Id: <10542.110659@fatcity.com>

Have you issued the stmt with the schema name ?. Also try with dbms_sql package.

Regards.

> -----Mensaje original-----
> De: Mike & Martha [SMTP:mmrose_at_home.com]
> Enviado el: Mi=E9rcoles 28 de Junio de 2000 11:09
> Para: Multiple recipients of list ORACLE-L
> Asunto: Dropping & re-Creating Sequences in PL/SQL

>=20
>=20

> Hello,

>=20
> I've been unable to get the following commands to 'compile' in a =
PL/SQL
> package body in Oracle 8.1.6 Version 2 (8i with NTS 4.0 SP 6a):

>=20

> DROP SEQUENCE sequence_name;

>=20

> CREATE SEQUENCE sequence_name;

>=20

> I get errors like the commands aren't recognized.

>=20

> When I try to use EXECUTE IMMEDIATE 'DROP SEQUENCE sequence_name'

>=20

> I still get compile errors.

>=20

> I can compile when I use to following:

>=20

> Temp VARCHAR2(60);

>=20

> Temp :=3D 'DROP SEQUENCE sequence_name';

>=20

> EXECUTE IMMEDIATE Temp;

>=20

> I would really appreciate some help here!

>=20

> Michael Rose
> mmrose_at_home.com

>=20
>=20
>=20

> --=20
> Author: Mike & Martha
> INET: mmrose_at_home.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 28 2000 - 09:15:39 CDT