Topic
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