| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1410 Silliness
Vladimir, you are 100% right :)
Thanks for your reply.
Lisa
-----Original Message-----
Sent: Thursday, January 02, 2003 1:48 PM
To: Multiple recipients of list ORACLE-L
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: ';
, 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:Received on Thu Jan 02 2003 - 13:19:55 CST
> 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: Vladimir.Begun_at_oracle.com 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: ListGuru_at_fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: Lisa.Koivu_at_efairfield.com 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: ListGuru_at_fatcity.com (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).
 |
 |