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 <[email protected]> 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
