OraFAQ Forum: SQL & PL/SQL » Oracle Message

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Message - <pck name.proc name> : 301 (9.2.0.8.0)

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

Oracle Message - <pck name.proc name> : 301 [message #606805]

Wed, 29 January 2014 08:59

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

I have one script and calling the package.procedure. This script is calling from Datastage Job. Frequently I am getting the below error when I run the job.

Oracle Message - Pkg name.proc name:301
Return Code - 35
Status - 1

Please advice what is the possibility to get this error.

Report message to a moderator

Re: Oracle Message - <pck name.proc name> : 301 [message #606807 is a reply to message #606805]

Wed, 29 January 2014 09:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

You have a mystery & we have no clues about what is in your code.

Report message to a moderator

Re: Oracle Message - <pck name.proc name> : 301 [message #606808 is a reply to message #606805]

Wed, 29 January 2014 09:09

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove all WHEN OTHERS from your package code.

Report message to a moderator

Re: Oracle Message - <pck name.proc name> : 301 [message #606815 is a reply to message #606808]

Wed, 29 January 2014 09:46

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Thank you very much Michel and Blackswan. I have got the problem solution with your answer.

Report message to a moderator

Re: Oracle Message - <pck name.proc name> : 301 [message #606816 is a reply to message #606815]

Wed, 29 January 2014 10:02

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which was?

Report message to a moderator

Re: Oracle Message - <pck name.proc name> : 301 [message #606818 is a reply to message #606816]

Wed, 29 January 2014 10:53

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

I have removed OTHERS exception.

OTHERS exception internally calling one procedure that is using one select statement. That select statement is returning 'no_data_found' exception.

Report message to a moderator

Previous Topic:	Can you any one help me to solve the unique constraint error
Next Topic:	Searching string with special characters using INSTR function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:32:39 CDT 2024