Error while importing stored procedure

Poornagirija · Post by **Poornagirija** » Tue Apr 26, 2005 3:07 am

hi,
im new to Datastage.im trying to use stored procedure in ODBC.
while importing from stored procedure definitions,im getting the following error

DSR.MetaGeta(GET.PROC>COLUMNS)(DSSQLprocedurecolumns("","SCC BCI ERROR:Error calling SQL Fetch-
SQLSTATE = 22003,NativeError = 0,ErrorMsg = [oracle][odbc]Numeric

Anyone can help me?

Thanks in advance.

regards,

poornagirija

ketfos · Post by **ketfos** » Tue Apr 26, 2005 9:48 am

Hi,
From the SQL Error, it looks you are trying to convert and the value it getting out of range, with loss of significant digits.
Please the the data types in the DataStage and the Stored Procedure you are using.

Thanks
Ketfos

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 27, 2005 4:55 am

Search result from MSDN is given below

Convert CS to NT. If the conversion results in a loss of significant digits, SQLSTATE 22003 (Numeric value out of range) is returned. If the conversion results in the loss of nonsignificant digits, SQLSTATE 01S07 (Fractional truncation) is returned.