Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
332 Posts
ACCEPTED ANSWER

Pinned topic Oracle cursor as input

‏2005-12-07T06:10:44Z |
Can DataStage TX handle an Oracle cursor as input? I get the following in my .dbl file:

<29209-001>: Validating the adapter command...
<29209-001>: Database type is Oracle
<29209-003>: Connecting...
<29209-003>: Host string: nbsch025_DRIM
<29209-003>: UserID : RIM_DEV
<29209-003>: Password : *******
<29209-003>: Connection to Oracle has been established.
<29209-003>: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
<29209-003>: Returned status: (0) Success
<29209-003>: Interface library version 6.7(306)
<29209-003>: Map: /app/rim/users/buyssp/slot_0/runtime/appdir1/cfg/mercator_maps/dev/../../../binaries/maps/test.mmc, Timestamp: Wed Dec 7
<29209-003>: Data being retrieved for input card 2.
<29209-003>: Database adapter: Oracle9i Version 6.7(306)
<29209-003>: Starting a database unload...
<29209-003>: Query : call ?= GetWLITest (1,'sada')
<29209-003>: Unsupported datatype returned is being treated as text.
<29209-003>: The columns are of the following types:
<29209-003>: Column 0 (RETURN_VALUE) type is <Unknown>.
<29209-003>: Column 1 (INPUT1) type is NUMBER(40,0).
<29209-003>: Column 2 (INPUT2) type is VARCHAR(4000).
<29209-003>: Number of buffers in fetch array = 8
<29209-003>: The procedure statement to be executed is:
<29209-003>: begin :z99 := GetWLITest(:a00,:a01); end;
<29209-003>: Error in: OCIStmtExecute
Message : ORA-06550: line 1, column 15:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

<29209-003>: Returned status: (-1009) Failed to execute the SQL statement
<29209-003>: Cleaning up and closing the transaction...
<29209-003>: Transaction rollback was successful.
<29209-003>: Returned status: (0) Success