Coba diberi "direct" grant terlebih dulu. SQL> GRANT SELECT ON V_$SQL_PLAN TO user_name;
cmiiw, bowo ---------------------------------------------- http://itunes.apple.com/jp/app/gaple/id338822389?mt=8 http://itunes.apple.com/jp/app/41-empat-satu/id347304852?mt=8 ---------------------------------------------- --- In [email protected], juanda hakim <juanda_...@...> wrote: > > tetep g bisa nich > ini setelah dicoba lagi > > 1 create or replace procedure coba > 2 is > 3 owner varchar2(30); > 4 begin > 5 SELECT OBJECT_OWNER INTO owner FROM V$SQL_PLAN WHERE OBJECT_OWNER = > 'HAKIM'; > 6 if SQL%NOTFOUND then > 7 DBMS_OUTPUT.PUT_LINE('coba lagi'); > 8 else > 9 DBMS_OUTPUT.PUT_LINE(owner); > 10 end if; > 11* end; > SQL> / > > Warning: Procedure created with compilation errors. > > SQL> show err > Errors for PROCEDURE COBA: > > LINE/COL ERROR > -------- ----------------------------------------------------------------- > 5/1 PL/SQL: SQL Statement ignored > 5/37 PL/SQL: ORA-00942: table or view does not exist > > > > > > ________________________________ > Dari: dedi humaedi <rhamdeen...@...> > Kepada: [email protected] > Terkirim: Sen, 4 Januari, 2010 09:40:44 > Judul: Re: [indo-oracle] procedure dari tabel V$SQL_plan > > gue bisa tuh..mau capturannya? liat di notetentangit.wordpress.com...thx > beware of sensitive case dan number of resultnya...ketika dieksekusi nanti > dia tuh akan ada error bahwa exact fetch more than number of row expected.. > kalo kamu buka dictionary semua yang ada di table_name ditulis > kapital..ikuti saja... > > On Sat, Jan 2, 2010 at 2:03 AM, juanda hakim <juanda_...@...> wrote: > > > > > > > SQL> create or replace procedure coba > > 2is > > 3 owner varchar2(30); > > 4 begin > > 5 select object_owner > > 6 into owner > > 7 from v$sql_plan > > 8 where object_owner = 'HAKIM'; > > 9 if SQL%NOTFOUND then > > 10 DBMS_OUTPUT.PUT_LINE('coba lagi'); > > 11 else > > 12 DBMS_OUTPUT.PUT_LINE(owner); > > 13 end if; > > 14 end; > > 15 / > > Warning: Procedure created with compilation errors. > > SQL> show err > > Errors for PROCEDURE COBA: > > LINE/COL ERROR > > -------- ---------------------------------------------------------- > > 5/1 PL/SQL: SQL Statement ignored > > 7/6 PL/SQL: ORA-00942: table or view does not exist > > > > SQL> declare > > 2 owner varchar2(30); > > 3 begin > > 4 select object_owner > > 5 into owner > > 6 from v$sql_plan > > 7 where object_owner = 'HAKIM'; > > 8 if SQL%NOTFOUND then > > 9 DBMS_OUTPUT.PUT_LINE('coba lagi'); > > 10 else > > 11 DBMS_OUTPUT.PUT_LINE(owner); > > 12 end if; > > 13 end; > > 14 / > > HAKIM > > PL/SQL procedure successfully completed. > > > > > > SQL> select owner, object_type from dba_objects where > > object_name='V$SQL_PLAN'; > > OWNER OBJECT_TYPE > > ------------------------------ ------------------- > > PUBLIC SYNONYM > > > > > > saya mau nanya,,kenapa pada procedure tersebut error??? > > ketika procedure tersebut iseng-iseng saya ganti ke dalam bentuk blok > > PL/SQL, ternyata perintah tersebut running... > > waaaah makin bingung,,,apakah metadata tidak bisa running dalam procedure?? > > padahal V$SQL_PLAN bersifat PUBLIC,,,saya memberikan hak akses DBA kepada > > HAKIM... > > thanx all. > > > > Berselancar lebih cepat. Internet Explorer 8 yang dioptimalkan untuk Yahoo! > > otomatis membuka 2 halaman favorit Anda setiap kali Anda membuka browser. > > Dapatkan IE8 di sini! > > http://downloads.yahoo.com/id/internetexplorer > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > Regards > Dedi Caesar Humaedi > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya > sekarang! http://id.mail.yahoo.com > > [Non-text portions of this message have been removed] >
