DSXchange

Hello Gurus,
I am new to Datastage TX/Mercator.
I am trying to create a Type Tree using ORACLE STORED PROCEDURE in Database Interface Designer.

I created a STORED PROC "EMPLOY".

But when I am trying to Generate the Type tree it is showing error message "The definition for procedure EMPLOY could not be accessed".

Can anyone please explain me what is the cause of this error.


Thanks
Ramesh

CHeck with ODBC connector Parameters , If its not working with ODBC Paramters Try with Oracle conncetor in DID , in some cases you need not sepcify UID and Passwd in DID .Gud Luck

nramesh wrote:Hello Gurus,
I am new to Datastage TX/Mercator.
I am trying to create a Type Tree using ORACLE STORED PROCEDURE in Database Interface Designer.

I created a STORED PROC "EMPLOY".

But when I am trying to Generate the Type tree it is showing error message "The definition for procedure EMPLOY could not be accessed".

Can anyone please explain me what is the cause of this error.


Thanks
Ramesh