DSXchange

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

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

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:

CALL DBMS_MVIEW.REFRESH('Test_VW')

I looked for a siminar post last night and found one that used CALL instead of BEGIN ... END;