DBA SCHEDULER JOB

DBMS_SQL paketinin kullanılması

DECLARE

Source_Cursor      INTEGER;

Num_Rows_Processed Integer;

BEGIN

Source_Cursor := Dbms_Sql.Open_Cursor;

     Dbms_Sql.Parse(Source_Cursor, 'select * from dba_source where object_name =  ', 1);

     Num_Rows_Processed := Dbms_Sql.EXECUTE(Source_Cursor);

     Dbms_Sql.Close_Cursor(Source_Cursor);

end;