Bisa ketikan perintah "show error" setelah compilation dan paste khan outputnya?
On 22/04/2008, suarto Wijaya <[EMAIL PROTECTED]> wrote: > > Saya juga melakukan 'execute in SQL *Plus' di toad dan ada message > 'Warning: > Procedure created with compilation errors.' > > > > Regards, > > > suarto > > ---------- Forwarded message ---------- > From: Yoel Susanto <HYPERLINK > "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]> > > Date: 18 Apr 2008 16:56 > Subject: Re: [indo-oracle] store procedure encryption > To: HYPERLINK > "mailto:[email protected]"[email protected] > > > bagaimana kalo di jalankan di SQL Plus > > > > > On 18/04/2008, suarto Wijaya <HYPERLINK > "mailto:suarto%40mayora.co.id<suarto%2540mayora.co.id> > " > > [EMAIL PROTECTED]> wrote: > > > > > Saya sdh melakukan seperti yg P'Yoel katakan di HYPERLINK > > > "HYPERLINK "http://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=58"; > \nhttp://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=58"; > > > HYPERLINK "http://www.indo/"; \nhttp://www.indo > > -HYPERLINK "http://oracletech.com/forum/viewtopic.php?f=6&t=58"; > \noracletech.com/forum/viewtopic.php?f=6&t=58 tapi waktu di execute as > > > scrip > > di toad ada error yaitu Warning: PROCEDURE created with compilation > > errors. > > > > > > > > Langkah2 pembuatan file wrapnya sbb: > > > > wrap iname=/u02/validation/cmo_new_030408_2.sql > > oname=/u02/validation/wrap_cmo.sql > > > > > > > > PL/SQL Wrapper: Release 10.2.0.1.0- Production on Fri Apr 18 09:33:46 > 2008 > > > > > > > > Copyright (c) 1993, 2004, Oracle. All rights reserved. > > > > > > > > Processing /u02/validation/cmo_new_030408_2.sql to > > /u02/validation/wrap_cmo.sql > > > > > > > > > > > > Padahal file sql tsb kalau execute as scrip tdk ada error(sebelum di > > wrap). > > > > > > > > OS server oracle-nya menggunakan redhat. > > > > Jadi dari windows file sql, saya copy ke linux, di linux saya create > file > > wrap lalu file wrap tsb saya copy ke windows. > > > > Kemudian saya open toad & dari file wrap tsb saya create procedure dgn > > menggunakan command/tanda petir 'execute as scrip', tapi ada error spt > di > > atas. > > > > Apakah langkah2 yg saya lakukan ada yg salah ? > > > > > > > > > > Thx > > > > suarto > > > > > > ---------- Forwarded message ---------- > > From: Yoel Susanto <HYPERLINK > > > "mailto:HYPERLINK > > "mailto:yoel.susanto%40gmail.com<yoel.susanto%2540gmail.com> > " > [EMAIL PROTECTED]"HYPERLINK > "mailto:yoel.susanto%40gmail.com<yoel.susanto%2540gmail.com> > " > [EMAIL PROTECTED]> > > Date: 14 Apr 2008 13:20 > > Subject: Re: [indo-oracle] store procedure encryption > > To: HYPERLINK > > > "mailto:HYPERLINK > > "mailto:indo-oracle%40yahoogroups.com<indo-oracle%2540yahoogroups.com> > " > [EMAIL PROTECTED]"HYPERLINK > "mailto:indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.com>" \ > [EMAIL PROTECTED] > > > > > Pak Suarto, > > > > Jawaban dan contoh bisa di liat di link dibawah > > > > > HYPERLINK "HYPERLINK > > "http://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=58"; > \nhttp://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=58"; > > \nhttp://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=58 > > > > -- > > Cheers, > > Yoel Susanto > > > > > HYPERLINK "HYPERLINK "http://www.indo-oracletech.com/"; > \nhttp://www.indo-oracletech.com/"; \HYPERLINK > "http://nwww.indo-oracletech.com/"; \nnwww.indo-oracletech.com > > > > > > > On 14/04/2008, suarto Wijaya <HYPERLINK "mailto:HYPERLINK > "mailto:suarto%2540mayora.co.id <suarto%252540mayora.co.id>" \nsuarto% > 40mayora.co.id<suarto%HYPERLINK > "http://2540mayora.co.id/"; \n2540mayora.co.id> > > > " > > \HYPERLINK "mailto:nsuarto%40mayora.co.id <nsuarto%2540mayora.co.id>" \ > [EMAIL PROTECTED]> wrote: > > > > > > Saya mau tanya cara meng-encryption store procedure oracle > > > > > > Thx > > > > > > suarto > > > > > > -- > > > No virus found in this outgoing message. > > > Checked by AVG Free Edition. > > > Version: 7.1.392 / Virus Database: 268.5.1/1374 - Release Date: > > 11-Apr-08 > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > -- > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.1.392 / Virus Database: 268.5.1/1374 - Release Date: > 11-Apr-08 > > > > > > -- > > No virus found in this outgoing message. > > Checked by AVG Free Edition. > > Version: 7.1.392 / Virus Database: 268.5.1/1374 - Release Date: > 11-Apr-08 > > > > > > > > [Non-text portions of this message have been removed] > > > > > > ------------------------------------ > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: HYPERLINK > > "mailto:indo-oracle-unsubscribe%40yahoogroups.com<indo-oracle-unsubscribe%2540yahoogroups.com> > " > [EMAIL PROTECTED] > > Website: HYPERLINK "http://indooracle.wordpress.com/"; > \nhttp://indooracle.wordpress.com > > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > > HYPERLINK "http://indo-thin.blogspot.comyahoo/"; > \nhttp://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > -- > > Cheers, > Yoel Susanto > > HYPERLINK "http://www.indo-oracletech.com/"; \nwww.indo-oracletech.com > > > [Non-text portions of this message have been removed] > > > > > > > -- > Internal Virus Database is out-of-date. > > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.5.1/1374 - Release Date: 11-Apr-08 > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > > Version: 7.1.392 / Virus Database: 268.5.1/1390 - Release Date: 21-Apr-08 > > > > > [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 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
