Title: RE: ORA-1410 Silliness
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
Title: ORA-1410 Silliness
Hi
Waleed,
No. This is the name of the package.
Thanks
Lisa
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 3:04
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
I see
ORACLE-LSubject:
RE: ORA-1410 Silliness
You
asked for it. Here goes. It is partitioned on
julian_run_date. Please don't hammer me about the design. I wasn't
given a chance to improve on it. It is basically a mainframe file that I
have stored history of.
SQL desc
vegas_martName
Nope...
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Did u do any migration recently .
"Koivu, Lisa" [EMAIL PROTECTED] wrote:
impossible but, what the hey?
Tom Mercadante Oracle Certified Professional
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003
8:14 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: ORA-1410 Silliness
Hi
Waleed
Title: RE: ORA-1410 Silliness
Amount of data, definately. This table grows by ~2.5GB weekly. Have you ever seen data volume begin to cause problems?
Thanks Rachel
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 5:05 PM
-1410 Silliness
Hi
Waleed,
No. This is the name of the package.
Thanks
Lisa
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
3:04 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-1410 Silliness
and also check the v$open_cursor when the error
happens...
Babu
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 02, 2003 8:14
AM
Subject: RE: ORA-1410 Silliness
Hi
Waleed,
No. This is the name
recipients of list ORACLE-LSubject:
RE: ORA-1410 Silliness
Nope...
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Did u do any migration
. This happens even if
the partition has been made USABLE after query start.
Good
luck
Ed
-Original Message-From:
Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December
31, 2002 12:49 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-1410 Silliness
You asked
total speculation since I'm not a PL/SQL expert -- could the amount of
data you are manipulating in the stored procedure somehow blow out
available memory?
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Amount of data, definately. This table grows by ~2.5GB weekly. Have
you
ever seen data volume
2003 8:31 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-1410 Silliness
Lisa,
This is probably nottrue ...
Oracle doesn't, has never been able to pinpoint exact line number (in
cases such as these) especially with pl/sql packages. I believe the problems
ca
Title: RE: ORA-1410 Silliness
Not at this point. I believe when the pl/sql tables get too big it blows up with ora-4031 or one of the common memory errors, I've seen it happen before. I may have only a stupid windows machine, but I have so much RAM... kudos to the brilliant people who didn't
Title: ORA-1410 Silliness
Lisa,
The answer is very, very simple...Don't take a
day off! No day off...no error...no failed
loads...
Seriously, it sounds like either an index corruption (temporary) or an oracle
bug. Is there anything in the alert log or in trace files? Try setting a trap on
Title: RE: ORA-1410 Silliness
I am no pl/sql expert either, but me think that would cause a ORA-4031 ... been there ... done that ... before I learned to code in a better way.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
Title: RE: ORA-1410 Silliness
Lisa,
try to see if you can (I think you should) use
dbms_session.free_unused_user_memory ... this is very handy for
applications where large pl/sql tables (oops ... arrays) are used
frequently.
Raj
Title: RE: ORA-1410 Silliness
Thanks
again Raj. I will definately look into it.
Lisa
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02,
2003 11:39 AMTo: Multiple recipients of list
ORACLE-LSubject: 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
Title: RE: ORA-1410 Silliness
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
Jamadagni, Rajendra wrote:
Lisa,
This is probably not true ...
Oracle doesn't, has never been able to pinpoint exact line number (in
cases such as these) especially with pl/sql packages. I believe the
problems can be found by executing following query ...
select line, type, source
Jamadagni, Rajendra wrote:
Oracle doesn't, has never been able to pinpoint exact line number (in
Can you please prove it? Do not you think that this statement
contradicts to the sql query you provided below. :) There is
quite some difference with GUI which pulls/[s]pools PL/SQL code
out and
Title: RE: ORA-1410 Silliness
Okay ... I need to be clearer ... this is because editors have no concept of line-of-code that Oracle uses. For Oracle one 3 page insert statement is one statement, whereas an editor will treat it as a bunch of line numbers (when it encounters a linefeed
Lisa,
Tuesday, December 31, 2002, 7:43:54 AM, you wrote:
KL Usually when this happens I can re-fire the load and it will
KL complete, no problem. It's a big annoyance and it seems like every
KL time I take a day off it happens.
How does it know you are taking a day off? Maybe you shouldn't set
Title: ORA-1410 Silliness
Sounds
like another Elvis sighting!!
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
7:44 AMTo: Multiple recipients of list ORACLE-LSubject:
ORA-1410 Silliness
Hello all,
8.1.7, Windows 2000 SP2
Title: ORA-1410 Silliness
Is
there a column with a datatype of rowid?
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
6:44 AMTo: Multiple recipients of list ORACLE-LSubject:
ORA-1410 Silliness
Hello all,
8.1.7, Windows
Title: ORA-1410 Silliness
Elvis? No way. It's got to be a Raelian
clone.
Ken Janusz
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 31, 2002 8:34
AM
Subject: RE: ORA-1410 Silliness
Sounds like
Title: ORA-1410 Silliness
Nope... nothing named rowid.
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Is
there a column with a datatype of rowid
Title: RE: ORA-1410 Silliness
Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask.
As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures
f ESPN Inc.
QOTD: Any clod can have facts, but
having an opinion is an art!
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
ORA-1410 Silliness
Elvis? No way
Title: ORA-1410 Silliness
Lisa,
What is your cursor doing?
Perhapsrow-migration is occuring thus causing the rowid to become
invalid?
Tom Mercadante Oracle Certified Professional
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
of list ORACLE-LSubject: Re:
ORA-1410 Silliness
Elvis? No way. It's got to be a Raelian
clone.
Ken Janusz
- Original Message -
From:
Farnsworth, Dave
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, December 31, 2002 8:34
AM
Subject
:
ORA-1410 Silliness
Elvis? No way. It's got to be a Raelian
clone.
Ken Janusz
- Original Message -
From:
Farnsworth, Dave
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, December 31, 2002 8:34
AM
Subject: RE: ORA-1410 Silliness
in the final table.
If any
of that makes sense. At this point nothing makes sense.
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
10:24 AMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: ORA-1410
Silliness
-1410 Silliness
Nope... nothing named rowid.
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Is
there a column with a datatype of rowid
Title: RE: ORA-1410 Silliness
Actually if you had a clone of your SA, you might have twice as many problems.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
If I had
Title: RE: ORA-1410 Silliness
Anything with a Materialized View??
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN Inc.
QOTD: Any
PROTECTED]]Sent: Tuesday, December 31, 2002 10:44
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
How
about posting the table structure and the lines around 1970 in the Elvis
package.
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL
Title: RE: ORA-1410 Silliness
Hi
Raj,
No
materialized view. That would be too high-tech for this company. And
it might kill Elvis more than once.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31,
2002 10:49 AMTo: Multiple
Lisa,
I am joining this thread late - so apologies if my suggestion has already
been looked into !
The first error message is ORA-01001 (Invalid Cursor). There is an article
on MetaLink (1007395.6) about the various causes for this error. Have you
read this article and verified that the
AMTo: Multiple recipients of list ORACLE-LSubject:
RE: ORA-1410 Silliness
You
asked for it. Here goes. It is partitioned on
julian_run_date. Please don't hammer me about the design. I wasn't
given a chance to improve on it. It is basically a mainframe file that I
have stored history
dumb question -- did you extract the insert statement and run it in
sqlplus? Does it run there or does it go boom as well?
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
You asked for it. Here goes. It is partitioned on julian_run_date.
Please
don't hammer me about the design. I wasn't given a
recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Very
straight forward. and LONG . (Yea, I read to your last
message).
Could that be the issue here ?? Is the record too long or
some buffer being overwritten in Oracle when there is so long of record and so
much data
Title: RE: ORA-1410 Silliness
Yes, I do exchange partition but the error happens long before I hit the procedure that does that. It blows up on the load.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 1:44 PM
To: [EMAIL
Title: RE: ORA-1410 Silliness
I just read it and most of these scenarios are specific to OCI. This is straight pl/sql. However I did check max open cursors (I believe that's a different error, I've seen that one before) and that's not the problem.
I may be wrong, but when an error happens I
Title: ORA-1410 Silliness
I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary
key index for a table?
If yes, then it
may need to be rebuilt.
Regards,
waleed
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
Title: RE: ORA-1410 Silliness
Hi Rachel,
Just tried it and it works. Thanks for your suggestion.
Lisa
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1410
Lisa
. Enable SQL tracing
. Launch your code
. Identify (exactly) the cursor which fails
with ORA-01410 and what bind vars are.
. Pull out the statement from your code
. Run it in 'standalone' mode
. If it fails identify rowids which look broken.
Check the phys. entities those rowids point
ecember 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness
Very straight forward. and LONG . (Yea, I read to your last message).
Could that be the issue here ?? Is the record too long or some buffer being overwritten in Oracle when there is so long
Okay this means that the statement itself, which is being pointed to by
the error line, is not the real culprit. Unfortunately, I don't know
of a good debugger for PL/SQL that lets you step through line by line.
let me rephrase that, I know of no freeware one :)
since you say this has only
49 matches
Mail list logo
