OraFAQ Forum: Server Administration » Stored Procedure error

Home » RDBMS Server » Server Administration » Stored Procedure error

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

Stored Procedure error [message #375159]

Wed, 01 August 2001 10:54

Revati
Messages: 2
Registered: August 2001

Junior Member

Hi,

I have a stored procedure named 'ORWTC11U' in database.
When I try to execute it via my code, I get following error
odessp(ProcedureName="ORWTC11U',position=0)failed
ORA-06564:object ORWTC11U does not exist
ORA-06512: at "SYS.DBMS_DESCRIBE", line 55

I checked via TOAD and procedure seems to be OK in database. What steps I can take to investigate the problem?

Thanks in Advance.

Report message to a moderator

Re: Stored Procedure error [message #375161 is a reply to message #375159]

Wed, 01 August 2001 13:22

Senthil
Messages: 68
Registered: December 1999

Member

are you trying to execute the stored-procedure from the same scheme or from the different schema. if it is on the same schema...the please provide more details...if it is accessed from the different schema...then are you executing/accessing with proper permissions...

Report message to a moderator

Re: Stored Procedure error [message #375162 is a reply to message #375161]

Wed, 01 August 2001 15:00

Revati
Messages: 2
Registered: August 2001

Junior Member

Hi Senthil,

Thanks for reply. By chance,I figured out it was permissions problem.I have a question still- how do I check permissions on stored procedures?

Report message to a moderator

Previous Topic:	setting transaction isolation level to read only
Next Topic:	calling an oracle stored procedure from an asp page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 06:10:17 CST 2024