Re: Passing tablename as parameter

>>
>> Hi,
>>
>> In my when-new-block trigger, I pass to a procedure the name of my table as
>> a varchar2. In the procedure
>> , I want the procedure to use the string as the table name, but it is not
>> letting me do that saying that my
>> passed string is not a tablename (it isn't, its the variable that CONTAINS
>> the tablename). Here's what I am doing
>> In the triger:
>> DECLARE
>> strvendor varchar2;
>> begin
>> FindVendorName(strvendor);
>> END;
>>
>> In the procedure FindVendorName (strvendor varchar2) return varchar2 IS
>> begin
>> select vendorname into :current.company from strvendor; --it is saying
>> strvendor is not tablename
>> return :current.company;
>> end;
>>
>> How can I pass the name of a table, column etc. as parameters that in the
>> called procedure are evaluated
>> first for their value and then processed in the SQL statement?
>>
>> Thanks.
>
>

Use the DBMS_SQL package to build and execute the SQL statement.

Dan Received on Sun Nov 21 1999 - 16:20:10 CET