Hi all,
how to call build in procedure from oracle oci stage , i want to run following pl/sql code from oci stage
begin DBMS_MVIEW.REFRESH('Test_VW'); end;
Thanks
rv
call buildin prceodure from oci stage
Moderators: chulett, rschirm, roy
Re: call buildin prceodure from oci stage
I am not sure if you wish to do this as a before or after proc. Assuming you wish to refresh your view after you insert data into a table, on the SQL/After tab, insert:Veni wrote:Hi all,
how to call build in procedure from oracle oci stage , i want to run following pl/sql code from oci stage
begin DBMS_MVIEW.REFRESH('Test_VW'); end;
Thanks
rv
CALL DBMS_MVIEW.REFRESH('Test_VW')
I looked for a siminar post last night and found one that used CALL instead of BEGIN ... END;