Refreshing Snapshots in PL/SQL?

[JeffShelley]

Is it possible to refresh a snapshot from a stored proc?

 

[rcurva]

yup, use dynamic sql.

For 8.x below use DBMS_SQL package.

v_delete := 'dbms_snapshot.refresh()';
v_cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE (v_cid,v_delete,DBMS_SQL.NATIVE);
dbms_sql.close_cursor(v_cid);

For 8i +, use execute immediate;

EXECUTE IMMEDIATE ('dbms_snapshot.refresh{}');