Coba pake BEGIN..EXCEPTION..END nested untuk setiap SELECT statement
Mis. untuk prosedur di bawah:
DECLARE
--variable...
BEGIN
--SELECT statement...
EXCEPTION
--WHEN...
--Start statement atau kondisi lain...
END;
Ganti menjadi:
DECLARE
--variable...
BEGIN
BEGIN
--SELECT statement...
EXCEPTION
--WHEN...
END;
--Start statement atau kondisi lain...
END;
hth,
AH
Kang Oyib wrote:
>
> Ya, sebagian sudah sya buat dengan cursor, tetepi ada beberapa yg masih
> menggunakan select.
> kalo detail errornya sih ini :
> *ORA-01403:*no data found*Cause:*In a host language program, all records
> have been fetched. The return code from the fetch was +4, indicating that
> all records have been returned from the SQL query.*Action:*Terminate
> processing for the SELECT statement. Bukan kah error tersebut justru pada
> cursornya....?
> Masalahnya semua cursor sudah saya check tidak ada masalah....
>
> Ada solusi lain...?
>
> thx...
>
> On 6/6/07, apachelynx <[EMAIL PROTECTED]
> <mailto:apachelynx%40yahoo.co.uk>> wrote:
> >
> > Allo Kan Oyib,
> >
> > Penyebabnya? bukannya sudah jelas, itu karena tidak ada data yg di
> > hasilkan
> > dari SELECT command.
> > - Kemungkinan pada blok PL/SQL anda menggunakan implisit "SELECT ...
> INTO
> > ..."
> > - Kemungkinan lain errornya bukan berada di tempat yg telah ada
> tambahkan
> > EXECPTION, mungkin berada di tempat/function/pkg lain.
> > - Mungking penempatan EXCEPTION nya kurang benar :D
> >
> > Solusinya, Coba gunakan cursor.
> >
> > Regards,
> > Aply
> >
> > ----- Original Message -----
> > From: "Kang Oyib" <[EMAIL PROTECTED] <mailto:kang.toyib%40gmail.com>>
> > To: <[email protected] <mailto:indo-oracle%40yahoogroups.com>>
> > Sent: Wednesday, June 06, 2007 14:01 PM
> > Subject: [indo-oracle] ora-01403
> >
> >
> > > Dear All,
> > >
> > > Ada yg tau penyebab dan solusi untuk ora-01403...?
> > > errornya sih menunjukkan no_data_found, tetapi semua select sudah saya
> > > beri
> > > exception when no_data_found tetapi masih keluar juga...
> > >
> > > thx...
> > >
> > > oyib
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > --
> > > -----------I.N.D.O - O.R.A.C.L.E---------------
> > > Keluar: [EMAIL PROTECTED]
> <mailto:indo-oracle-unsubscribe%40yahoogroups.com>
> > > Website: http://indo-oracle.blogspot.com
> <http://indo-oracle.blogspot.com>
> > > Mirror: http://indooracle.wordpress.com
> <http://indooracle.wordpress.com>
> > > -----------------------------------------------
> > >
> > > Bergabung dengan Indonesia Thin Client User Groups,
> > > Terminal Server, Citrix, New Moon Caneveral, di:
> > > http://indo-thin.blogspot.com <http://indo-thin.blogspot.com>
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >
> > --
> > -----------I.N.D.O - O.R.A.C.L.E---------------
> > Keluar: [EMAIL PROTECTED]
> <mailto:indo-oracle-unsubscribe%40yahoogroups.com>
> > Website: http://indo-oracle.blogspot.com
> <http://indo-oracle.blogspot.com>
> > Mirror: http://indooracle.wordpress.com
> <http://indooracle.wordpress.com>
> > -----------------------------------------------
> >
> > Bergabung dengan Indonesia Thin Client User Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo-thin.blogspot.com <http://indo-thin.blogspot.com>
> > Yahoo! Groups Links
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
