Importing Oracle stored procedure definition in Datastage

[Sravani]

Hi Gurus,

I have created a small Oracle stored procedure which returns an integer. Now, I would like to use the stored procedure into datastage job. For that I am trying to import the Stored Procedure definition after doing the following steps.
1) Updated uvodbc.config file on UNIX server with the following details
<TEST>
DBMSTYPE = ORACLE
network = TCP/IP
service = ServiceName
host = xxx.xx.xx.xx
2) Using import option in Datastage designer I have browsed for the above added DSN. But when clicks on OK I am getting the following error.

DSR.MetaGeta(GET.PROCS): This function is not supported for DBMSTYPE 'TEST'.

Can any body help me in resolving this?

Thanks in advance.

[ray.wurlod]

DBMSTYPE must only be one of ODBC or UNIVERSE in the uvodbc.config file.

Having changed it to ODBC, you must then set up an ODBC data source name (DSN) that points to the correct Oracle TNS name. DSNs are configured in the $ODBCINI file. It is also necessary that the TNS name be correctly configured in tnsnames.ora on the DataStage server machine.