Toad World® Forums

identifier must be declared error


#1

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


#2

Todd,

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

[package_name].[proc_name]

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 support@unit-test.com and I will take a look?

Thanks, SF


#3

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

Thanks

Todd