Home » SQL & PL/SQL » Client Tools » problem with toad, ORA-04043, ORA-12638
problem with toad, ORA-04043, ORA-12638 [message #285090] Mon, 03 December 2007 06:36 Go to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
When I am trying to debug any packaged function in TOAD,
after I enter the parameters, and press F8..

I get the following errors

ALTER PACKAGE "myschema".functname compile debug body
ORA-04043: object functname does not exist

and if i continue either by pressing continue script button or ignore all errors button
, I get the following error

ORA-12638: Credential retrieval failed



when i googled, i got the idea that the name of the package or function is spelt wrong...but if thats the case, then the
package has to be in invalid state..is it not?

but all my packages are valid..but i am not able to debug
the things...causing obstruction to my daily activities

Re: problem with toad, ORA-04043, ORA-12638 [message #285091 is a reply to message #285090] Mon, 03 December 2007 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't compile a function inside a package, you compile the whole package.

Regards
Michel
Re: problem with toad, ORA-04043, ORA-12638 [message #285094 is a reply to message #285090] Mon, 03 December 2007 06:49 Go to previous messageGo to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
thats right, and no matter when i am trying to debug a standalone function, or a
packaged function, i am getting this error for only one
particular package..i mean, saying that particular package doesnt exist

Re: problem with toad, ORA-04043, ORA-12638 [message #285097 is a reply to message #285094] Mon, 03 December 2007 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And so it does not exist.
Check the name you gave.
Beware that enclosing them between " implies case sensitivity.

Regards
Michel
Re: problem with toad, ORA-04043, ORA-12638 [message #285100 is a reply to message #285090] Mon, 03 December 2007 07:18 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Or if it does exist, perhaps you don't have the proper grants to view/execute it.
Previous Topic: Update Statement
Next Topic: Columns position in TOAD
Goto Forum:
  


Current Time: Wed Dec 07 18:23:41 CST 2016

Total time taken to generate the page: 0.12749 seconds