Re: Table Names as Parameters

From: Bill Frost <Bill.Frost_at_NOSPAM.hpa.com.au>
Date: Wed, 7 Apr 1999 09:33:49 +1000
Message-ID: <7ee5n7$qis$1@m2.c2.telstra-mm.net.au>

You will have to use the dbms_sql package to parse, bind and execute a dynamic SQL statement.

:)BF

DelphiDev <delphidev_at_yahoo.com> wrote in message news:370A1A44.AACA3FFC_at_yahoo.com...
> Is there a way to pass a table name to a stored procedure:
>
> PROCEDURE ADDCODE (mfilecode CHAR, new_code CHAR, new_desc CHAR) IS
> BEGIN
> INSERT INTO mfilecode
> VALUES (new_code, new_desc);
> END ADDCODE;
>
>
> Thanks, Stan.
>
Received on Tue Apr 06 1999 - 18:33:49 CDT