Toad World® Forums

identifier must be declared error


I have a situation where I am connect to the database as a testuser and testing a program in another schema. I get the identifier [package_name].[proc_name] must be declared when I try to compile the test code.

Any ideas?

Todd Slaughter



Do you mean that you literally see a message with this text in it:


That would be worrisome.

It is a bit hard to diagnose this with the info you gave me. Could you please send the header of your program and an export of the test definition to and I will take a look?

Thanks, SF


I found out what the problem was, it was a permissions issue with the user account I was connecting as. I had to add permission to execute any procedure since I was testing a procedure in another schema.

basic stuff really