Re: ORA-01403 - no data found

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 3 May 1999 23:54:46 +0200
Message-ID: <925768355.10002.0.muttley.d4ee154e@news.demon.nl>

Hi Uri,

I would probably start doubting which sql-statements really are being executed on the server.
Then I would try two different approaches: port the statement to sql*plus
and two: put the instance in trace mode by setting sql_trace = true in init<sid>.ora. This is the only method to retrieve the statements which retrieve no data, the error message will also appear in the trace file.

Hth,

Sybrand Bakker, Oracle DBA

uri bargil wrote in message <372DE06F.44DC5A1A_at_trans-planet.com>...
>Hello
>Im using Oracle DB 8 with OAS 4.0.7 on SUN SOLARIS 2.6.
>I try to execute some sql statements using OCI.
>No matter what I do I get the error in the subject.
>there is defenatelly data in thr DB.
>What can be the problem?
>How can I solve it?
>Thank you.
>uri
>e-mail : uri_at_trans-planet.com
>
Received on Mon May 03 1999 - 16:54:46 CDT