| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Fetch out Sequence on cursor |
« View previous topic :: View next topic » |
| Author |
Message
|
| nikhilsawant097 |
 Posted: Mon Sep 10, 2018 8:47 pm Post subject: Fetch out Sequence on cursor |
 |
|
Newbie
Joined: 24 May 2018
Posts: 6
|
Hi, I'm calling a stored procedure from external db with 2 IN parameter and 1 out parameter and a out cursor.
While testing on DB it's working fine, the records are fine, but while testing on IIB it's giving me ORA-01002.
Actually thing i have observed is cursor is reading a extra row which is not present in actual output.
| Code: |
| CALL DTLS_TEST(param1,param2,Environment.error,Environment.ResultSet[]); |
for safe-side i have kept parameters name same on both side. |
|
| Back to top |
|
 |
| nikhilsawant097 |
| Posted: Mon Sep 10, 2018 8:58 pm Post subject: |
|
|
Newbie
Joined: 24 May 2018
Posts: 6
|
| Quote: |
| Actually thing i have observed is cursor is reading a extra row which is not present in actual output. |
Yes this is happening, i got the row count on DB as 1, but in IIB it's trying to get 2 records. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
