Home » RDBMS Server » Enterprise Manager » ORA-01422: exact fetch returns more than requested number of rows
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
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:
  


Current Time: Mon May 16 17:01:07 CDT 2022