Originally posted by: SystemAdmin

I'm using Database Interface Designer V8.1, Build 114 with Oracle driver version 8.01.07. I am trying to generate a type tree for the ADD_JOB_HISTORY stored procedure from one of the Oracle sample databases that my DBA created for me (in the HR schema).

The database has been created in 10g and 9i versions of Oracle, but I keep getting this error from DID: "The definition for procedure ADD_JOB_HISTORY could not be accessed." I've tried turning on the DID trace facility, but I'm not getting any Oracle error codes to indicate why the definition can't be accessed.

My userid has been assigned DBA privileges, and the dba unlocked the schema owner (HR) for me to try, but I still can't get the definition.

I CAN get definitions for Tables and Views, just not procedures. Is there something else that needs to be configured on my side or the database?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I also got the same error for my stored procedure when i tried to generate typetrees.
I think we need a patch for this from IBM.This happens only in 8.1.One solution is ceate a type tree in 8.0 and open it in 8.1.simple right!I did it the sameway
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I didn't have 8.0 around (we upgraded directly to 8.1), but I was able to use Datastage TX 7.5.1 to generate the tree.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Update:

I was also able to generate the type tree by downloading the 8.1.0.3 design studio.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender