Re: native dynamic sql

On 29 Sep 2003 17:17:24 GMT, odba1961_at_aol.com (Odba1961) wrote:

>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;

Just call it like you call any other procedure, which you can look up in your manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 29 2003 - 12:30:50 CDT