saya sdh berhasil mencompile store procedure dgn wrap & di execute di sql plus tanpa error. ternyata hanya gara2 spasi,yaitu :
Create or replace procedure test is versi number(3); -------------------- *di compile di sql*plus** pasti error.* lalu saya tambahkan space menjadi Create or replace procedure test is -----------------space----------------------- versi number(3); -------------------- *di compile di sql*plus tdk ada error.* ** thx atas supportnya dari para expert di indo oracle. On 5/7/08, xman widjaya <[EMAIL PROTECTED]> wrote: > > saya juga pusing deh, krn pada store procedure yg dimaksud tdk ada tanda > "" seperti yg ditulis 'show errors' > > thx > > > On 5/2/08, Yoel Susanto <[EMAIL PROTECTED]> wrote: > > > > wah pusing deh :) > > > > 2008/5/2 xman widjaya <[EMAIL PROTECTED] <xman0605%40gmail.com>>: > > > > > saya masih bingung sebab error yg dimaksud pada posisi baris/kolom tsb > > > tidak ada symbol "". > > > error sbb: > > > > > > LINE/COL ERROR > > > -------- ---------------------------------------------------------- > > > 55/44 PLS-00103: Encountered the symbol "" when expecting one of the > > > following: > > > begin function package pragma procedure subtype type use > > > <an identifier> <a double-quoted delimited-identifier> form > > > current cursor > > > The symbol "" was ignored. > > > > > > 138/33 PLS-00103: Encountered the symbol "" when expecting one of the > > > following: > > > begin case declare exit for goto if loop mod null pragma > > > raise return select update while with <an identifier> > > > > > > LINE/COL ERROR > > > -------- ---------------------------------------------------------- > > > <a double-quoted delimited-identifier> <a bind variable> << > > > close current delete fetch lock insert open rollback > > > savepoint set sql execute commit forall merge pipe > > > The symbol "" was ignored. > > > 464/25 PLS-00103: Encountered the symbol "" when expecting one of the > > > following: > > > begin case declare end exception exit for goto if loop mod > > > null pragma raise return select update while with > > > <an identifier> <a double-quoted delimited-identifier> > > > <a bind variable> << close current delete fetch lock insert > > > open rollback savepoint set sql execute commit forall merge > > > pipe > > > The symbol "" was ignored. > > > > > > thx > > > suarto > > > > > > > > > On 4/30/08, Yoel Susanto <[EMAIL PROTECTED]<yoel.susanto%40gmail.com> > > <yoel.susanto%40gmail.com>> > > > wrote: > > > > > > > > seperti yang saya sudah anjurkan. > > > > > > > > Bisa kah ketik show error ketika anda lakukan 'execute in sqlplus' > > di > > > > toad? > > > > untuk melihat error nya kenapa. > > > > > > > > 2008/4/30 xman widjaya <[EMAIL PROTECTED] > > > > <xman0605%40gmail.com><xman0605% > > 40gmail.com><xman0605% > > > 40gmail.com>>: > > > > > > > > > saya-pun sdh mencoba utk compile menggunaka wrap yg under windows, > > > > > hasilnya > > > > > juga sama yaitu error waktu file wrapnya di compile menggunakan > > > 'execute > > > > > as > > > > > script' ataupun menggunakan 'execute in sql*plus' di toad. > > > > > saya jadi bingung krn sdh mencoba di windows or di linux. > > > > > > > > > > thx > > > > > suarto > > > > > > > > > > > > > > > On 4/28/08, Yoel Susanto <[EMAIL PROTECTED]<yoel.susanto%40gmail.com> > > <yoel.susanto%40gmail.com> > > > <yoel.susanto%40gmail.com> > > > > <yoel.susanto%40gmail.com>> > > > > > wrote: > > > > > > > > > > > > Coba apakah saya mengerti keadaan anda dengan benar. > > > > > > Jadi anda create wrap script di Linux RedHat kemudian run > > scriptnya > > > > > > melalui > > > > > > windows TOAD dan/atau SQL Plus. > > > > > > > > > > > > kenapa Anda tidak menggunakan wrap yang under windows karena > > anda > > > akan > > > > > > createnya melalui windows client? > > > > > > > > > > > > 2008/4/28 xman widjaya <[EMAIL > > > > > > PROTECTED]<xman0605%40gmail.com><xman0605% > > 40gmail.com><xman0605% > > > 40gmail.com><xman0605% > > > > 40gmail.com><xman0605% > > > > > > > > 40gmail.com>>: > > > > > > > > > > > > > saya menbuat store procedurenya melalui toad under windows, di > > > > compile > > > > > > > melalui toad & tdk ada error lalu store procedure tsb saya > > running > > > > > > melalui > > > > > > > schejule oracle & hasil nya sesuai dgn perhitungan, OS server > > > oracle > > > > > > > menggunakan RETHAT. saya menggunakan wrap oracle yg running > > under > > > > > linux > > > > > > > lalu > > > > > > > hasil wrap tsb saya compile di toad maupun melalui sql*plus, > > hasil > > > > > dari > > > > > > > keduanya error. tapi ada programmer vendor yg buat store > > procedure > > > > di > > > > > > > server > > > > > > > oracle kami & di encrypt & berhasil. Saya pernah liat dia > > > > menggunakan > > > > > os > > > > > > > windows 2000 melalui toad utk mencreate store procedure & di > > > > encrypt. > > > > > > saya > > > > > > > sdg mencoba tapi gagal. > > > > > > > apakah para pakars di indo oracle dpt membantu saya ? > > > > > > > > > > > > > > thx > > > > > > > suarto > > > > > > > > > > > > > > > > > > > > > On 4/26/08, catur priyo nugroho <[EMAIL > > > > > > > PROTECTED]<catur.pb%40gmail.com> > > <catur.pb%40gmail.com> > > > <catur.pb%40gmail.com> > > > > <catur.pb%40gmail.com> > > > > > <catur.pb%40gmail.com><catur.pb% > > > > > > 40gmail.com>> > > > > > > > wrote: > > > > > > > > > > > > > > > > sekedar informasi saja... > > > > > > > > kalau file text di linux dan windows berbeda, terutama di > > akhir > > > > > baris > > > > > > > > kalau > > > > > > > > kita tekan enter/return. > > > > > > > > di windows akhir baris ada CR + LF > > > > > > > > di linux hanya ada 1 saja (lupa saya apa namanya.) > > > > > > > > jadi file text yg di buat di windows pasti akan error jika > > di > > > > > execute > > > > > > di > > > > > > > > lingkungan linux demikian juga sebaliknya. > > > > > > > > > > > > > > > > mohon maaf jika tidak membantu... > > > > > > > > kalau salah mohon di koreksi > > > > > > > > > > > > > > > > salam hormat, > > > > > > > > > > > > > > > > yo2k > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Cheers, > > > > > > Yoel Susanto > > > > > > > > > > > > www.indo-oracletech.com > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Cheers, > > > > Yoel Susanto > > > > > > > > www.indo-oracletech.com > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > -- > > Cheers, > > Yoel Susanto > > > > www.indo-oracletech.com > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed]
