rowtype pl/sql function in a view
Posted on 2011-02-16
I am trying to use a function I have built inside a view and I want to pass the whoel row into the function.
create or replace view Mac_Commis_Rev_Dtl_ial as
,JA_TEST.Commission_Zip (u.* ,x.* ) Zip_code
from mac_commission_revenue_tab x
where u.product_group_code = x.cest_product_group_code
WITH read only;
my function works inside a normal pl/sql block, but I want to generaically pass the row to the function. This will help me with maintanence.
I dont want to list out each column name from the table, just want to pass the row
Currently I get a ORA-01747 error