Page 1 of 1
Import Stored Procedure - Oracle
Posted: Tue Oct 30, 2007 8:12 pm
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
Re: Import Stored Procedure - Oracle
Posted: Thu Nov 01, 2007 8:32 am
by wenfei.chen
The answer is YES. You need to set up a DSN in .odbc.ini and uvconfig under your project.
Posted: Thu Nov 01, 2007 1:12 pm
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
Posted: Thu Nov 01, 2007 11:58 pm
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.