Hi i am calling an oracle packeged procedure
this is how i am calling it
ENGINE SQLORA SET DEFAULT_CONNECTION (Connector Name)
SQL SQLORA
EX Package_Name.Procedure_Name;

TABLE FILE SQLOUT
PRINT
*
END

when i do this i am getting the following error message.

"(FOC1400) SQLCODE IS 6564 (HEX: 000019A4)
: ORA-06564: object does not exist
L (FOC1405) SQL PREPARE ERROR"


But, when i call the same procedure with user name (EX User_Name.Package_Name.Procedure_Name; ) it's working fine.

Can anyone explain why the user name is required?

Note: Stand alone procedure works fine without user name.

Thanks
Adesh

Just guessing but it could be a couple of reasons

1. the ID used to connect to Oracle not the same as the user you enter in the SQL procedure.

2. There are more then one object with the same name.