a ref cursor variable might work too
Chris Jordan wrote:
>
> 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.
Received on Fri Nov 19 1999 - 12:02:33 CST
