| ORA-12801error [message #421008] |
Thu, 03 September 2009 11:36  |
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
|
Member |
|
|
Hi Gurus,
Please suggest me for the following error:
Error Message:
Server:Redhat Linux
Database: Oracle 10g(10.2.0.2)
Error occur while running auto job:(Daily manner auto job)yerterday went fine today has problem)
Job failed due to reason:
ORA-01722: invalid number
Error in: MAIN FATAL. ORA-20001:
INP2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in
parallel qu
Error in: PGM_START FATAL. ORA-20001: INP2123;01.06;MAIN;;;
ORA-20001:
INP2123;01.06;yyyy_1;drop_indexes;;
ORA-128
begin
*
ERROR at line 1:
ORA-20001: START;01.00;PGM_START;Start PL program: INP2123;ORA-20001:
INP2123;01.06;MAIN;;;
ORA-20001: test2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in parallel query server P021
ORA-01722: invalid number;
ORA-20001: test2123;01.06;MAIN;;;
ORA-20001: test2123;01.06;yyyy_1;drop_indexes;;
ORA-12801: error signaled in parallel query server P021
ORA-01722: invalid number
ORA-06512: at "test.test_COMMON", line 318
ORA-06512: at "test.PGM_START", line 96
ORA-06512: at line 2
Tried options:
--------------
I have checked objects status for "test2123" package(valid)
Enough tablespace free space is avaialble.
Any suggestions ???
Thanks in advance
Regards
Srivasu
|
|
|
|
| Re: ORA-12801error [message #421019 is a reply to message #421008] |
Thu, 03 September 2009 12:26  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>ORA-01722: invalid number
means a non-numeric character was being assigned to a NUMBER.
you need to find & fix it.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
