protected void page_load(object sender, eventargs e)
{
　//顯示當前時間，以便判斷是否為緩存中頁面
　this.label1.text = "cachebyoracledependency:" + datetime.now.tostring();
　//緩存依賴于文件textfile.txt
　string filedependencypath = server.mappath("textfile.txt");
　response.addfiledependency(filedependencypath);
　// 設置緩存的過期時間為120秒。
　response.cache.setexpires(datetime.now.addseconds(120));
　response.cache.setcacheability(httpcacheability.public);
　response.cache.setvaliduntilexpires(true);
}

create or replace trigger
"scott"."test_cache_by_oracle_dependncy" after
insert
or update
or delete of "deptno", "dname", "loc" on "scott"."dept" declare
file_handle utl_file.file_type;
begin
--打開文件
file_handle := utl_file.fopen('filepath','textfile.txt','w');
--將當前系統時間寫入文件
if utl_file.is_open(file_handle) then
　utl_file.put_line(file_handle,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
end if;
--關閉文件
utl_file.fclose(file_handle);
exception
when others then
begin
　if utl_file.is_open(file_handle) then
　　utl_file.fclose(file_handle);
　end if;
exception
　when others then
　　null;
　end;
end;