Import Stored Procedure - Oracle

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rcdhawan
Participant
Posts: 15
Joined: Wed Sep 12, 2007 7:04 pm

Import Stored Procedure - Oracle

Post by rcdhawan »

Please advise how to import the stored procedure defintion from Oracle Database? Does it also requires to set up an ODBC data source for Oracle to import Oracle store procedure? Thanks Dhawan
Top
wenfei.chen
Participant
Posts: 15
Joined: Mon Mar 20, 2006 2:03 pm

Re: Import Stored Procedure - Oracle

Post by wenfei.chen »

The answer is YES. You need to set up a DSN in .odbc.ini and uvconfig under your project.
What's the next?
Top
ds_developer
Premium Member
Premium Member
Posts: 224
Joined: Tue Sep 24, 2002 7:32 am
Location: Denver, CO USA

Post by ds_developer »

You do not need ODBC. In Manager, go to Import, Table Definitions, Stored Procedure Definitions... From there you will have to login to the Oracle database and find the Stored Procedure.

John
Top
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Dhawan,
At Import Meta Data (Stored Procedures), You will be asked to select the DSN from the dropdown box. So, you definitely must do what wenfei.chen said.
Top
Post Reply

Return to “General”