Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> native dynamic sql

native dynamic sql

From: Odba1961 <odba1961_at_aol.com>
Date: 29 Sep 2003 17:17:24 GMT
Message-ID: <20030929131724.02137.00000022@mb-m01.aol.com>

Can someone please tell me how to call the following procedure. Say I wanted to get rid of a table called dummy using the following procedure, how would I be able to do it? Thanks

create or replace procedure DropTable (p_Table in varchar2) as

      
      v_SQLString varchar2(100);

BEGIN
     
     v_SQLString := 'DROP TABLE '||p_Table;

EXECUTE IMMEDIATE V_SQLSTRING; END DropTable; Received on Mon Sep 29 2003 - 12:17:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US