Problem creating Type Tree using Stored Procedure

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
nramesh
Participant
Posts: 1
Joined: Wed Sep 12, 2007 7:12 am

Problem creating Type Tree using Stored Procedure

Post by nramesh »

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
Top
Sashi09
Participant
Posts: 2
Joined: Tue Dec 16, 2008 12:58 pm
Location: VIZAG

Re: Problem creating Type Tree using Stored Procedure

Post by Sashi09 »

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
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage TX”