Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> native dynamic sql
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