Calling procedures within another procedure of same schema where the schema is different from the connected user
Posted on 2005-03-01
My database is DB2 UDB 8.1 Fix Pack 6a. I need to call procedures within another procedure. The number of called procedures are high as the database intensive processing is high and on huge volume.
All the procedures are in the same schema APPL01. The connection user is APPLUSER. The called procedure is inoked as "call < called procedure>;". On compiling the calling procedure I get errors like "Cannot access APPL01.<called procedure>". The compilation error is solved when the call is changed to "call APPL01.< called procedure>;".
The Schema name cannot be hard coded in Calling procedure as the Schema name can change on installations.
Please help. Is there any way to sort this problem?
Thanks in advance,