Vladimir, you are 100% right :)
Thanks for your reply.
Lisa
-----Original Message-----
From: Vladimir Begun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 1:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1410 Silliness
Lisa
. I've read some messages of this thread -- there is 100% probability :)
that you incorrectly identified the statement which errors 1410.
PL/SQL engine could not point to the line 1970 -- it's in the middle
of the statement -- something is strange there. Do you handle exceptions
in your code? I can bet it's raised from the exceptions handler block.
Another 100% probability -- you do use GUI(?), which incorrectly shows
PL/SQL code lines? :)
ACCEPT l1 PROMPT 'From line: ';
ACCEPT l2 PROMPT 'To line: ';
ACCEPT l3 PROMPT 'Obj: ';
COLUMN LINE FORMAT 99999;
COLUMN TEXT FORMAT A70;
SELECT line
, text
FROM user_source
WHERE name = UPPER('&l3')
AND line BETWEEN &l1 AND &l2
ORDER BY type, line
/
. Inline view in the example is just an illustration how indexes can
point to the wrong rowid...
. Did you enable tracing? Do it -- you'll find *everything*.
Kind Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Koivu, Lisa wrote:
> Vladimir,
>
> Thanks for your reply.
> I have tested the cursor. It does not include any bind variables.
> There are no "broken rowids", as all objects passed analyze ... validate
> structure cascade.
> I also tested the scenario you describe in your code below. The code
> does break with that error, however there are no inline views in my code.
>
> Lisa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
