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 <[email protected]>
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 <[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
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]
