Re: Deleting tables via a SP

Hello Robert,

Use Dynamic SQL - DBMS_SQL package.

Hth,

Erika

Robert Vabo wrote:
>
> I want to use a stored procedure to delete a lot ov tables one table at a
> time.
>
> In VB I wrote a component that returns a recordset containing the tables. I
> want to loop that rs, get tablenames (do some checks) and then call a sp to
> drop/delete the tables.
>
> CREATE PROCEDURE spDelTempTables ( TableName IN varchar2 )
> AS
> BEGIN
> DROP TABLE + TableName;
> END;
>
> Any help to get out there ??
>
> --
> Regards
> Robert Vabo
> Application developer
> Gecko Informasjonssystemer AS
> www.gecko.no
> robert.vabo_at_gecko.no
Received on Fri Aug 25 2000 - 16:19:06 CEST