OraFAQ Forum: Enterprise Manager » ORA-01422: exact fetch returns more than requested number of rows

Home » RDBMS Server » Enterprise Manager » ORA-01422: exact fetch returns more than requested number of rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01422: exact fetch returns more than requested number of rows [message #68875]

Mon, 27 December 2004 22:42

Vidyanand More
Messages: 35
Registered: January 2003

Member

Hi All,
Oracle (R) Enterprise Manager
Ver: 9.2.0.1.0 Production

I created & submitted a job in OEM which invokes Process Flow (The process flow consist of PL-SQL API's and unix shell scripts.).

The job fails in OEM & displays following error message.

Session altered.

Role set.

Stage 1: Decoding Parameters
| location_name=PF_STG_LOC
| task_type=ProcessFlow
| task_name=PF_STG_CARRIER
Stage 2: Opening Task
declare
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "OWB_RUN_OWN.WB_RT_API_EXEC", line 17
ORA-06512: at "OWB_RUN_OWN.WB_RT_API_EXEC", line 137
ORA-06512: at "OWB_RUN_OWN.WB_RT_API_EXEC", line 164
ORA-06512: at line 205

child process exited abnormally
nms-915: The Job failed, error code=

This is happening for one specific job only.
Can someone please help me?

Thanks in Advance.

Regards,
Vidyanand

Report message to a moderator

Previous Topic:	How to maintain deployment to testing and testing to production
Next Topic:	How to find Oracle Edition(i.e Enterprise/Standard)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 07:39:27 CST 2024