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]
