ora_fetch() - Error ORA-01002: fetch out of sequence
Hi all,
I recently compiled oraperl in my HP-UX running oracle 7.1.3.
I was testing some sample programs and my perl script fails
when an ora_fetch() is encounterd. I wrote a C code and used "ofen"
it works fine. Has anyone compiled and used oraperl in a HP
platform running oracle 7.1.3. I am touch with the author and
he is also working on it. Any help in this regard would be
highly appreciated.
Thanks
commit.pl trace file:
% oraperl commit.pl -#8
1: info: ora_debug set to d,entry,exit,info:t:N
2: >ora_login
3: | entry: ora_login("XXXXX", "YYYYY", "ZZZZZ")
4: | >ora_getlda
5: | | entry: ora_getlda(void)
6: | | >ora_getcursor
7: | | | entry: ora_getcursor(void)
8: | | | exit: returning 0x40013508
9: | | <ora_getcursor
10: | | exit: returning 0x40013508
11: | <ora_getlda
12: | >set_sid
13: | | entry: set_sid(user01)
14: | | info: setting ORACLE_SID to user01
15: | <set_sid
16: | >set_sid
17: | | entry: set_sid(<NULL>)
18: | | info: resetting ORACLE_SID to user01
19: | <set_sid
20: | exit: returning lda 0x40013508
21: <ora_login
22: >ora_do
23: | entry: ora_do(0x40013508, "create table primes (prime number)")
24: | >ora_open
25: | | entry: ora_open(0x40013508, "create table primes (prime number)", 1174405120)
26: | | >check_lda
27: | | | entry: check_lda(0x40013508)
28: | | | >ora_findcursor
29: | | | | entry: ora_findcursor(0x40013508)
30: | | | | exit: is a cursor
31: | | | <ora_findcursor
32: | | | exit: is an lda
33: | | <check_lda
34: | | >ora_getcursor
35: | | | entry: ora_getcursor(void)
36: | | | exit: returning 0x40013b88
37: | | <ora_getcursor
38: | | >count_colons
39: | | | entry: count_colons("create table primes (prime number)")
40: | | | exit: count_colons: returning 0
41: | | <count_colons
42: | | info: statement contains 0 colons
43: | | info: statement returns no data
44: | | exit: returning csr "0x40013b88"
45: | <ora_open
46: | info: 0 rows processed
47: | >ora_close
48: | | entry: ora_close(0x40013b88)
49: | | >check_csr
50: | | | entry: check_csr(0x40013b88)
51: | | | >ora_findcursor
52: | | | | entry: ora_findcursor(0x40013b88)
53: | | | | exit: is a cursor
54: | | | <ora_findcursor
55: | | | exit: is a csr
56: | | <check_csr
57: | | >ora_dropcursor
58: | | | entry: ora_dropcursor(0x40013b88)
59: | | | exit: completed
60: | | <ora_dropcursor
61: | | exit: returning OK
62: | <ora_close
63: | exit: returning 0
64: <ora_do
65: >ora_open
66: | entry: ora_open(0x40013508, "insert into primes values(:1)", 5)
67: | >check_lda
68: | | entry: check_lda(0x40013508)
69: | | >ora_findcursor
70: | | | entry: ora_findcursor(0x40013508)
71: | | | exit: is a cursor
72: | | <ora_findcursor
73: | | exit: is an lda
74: | <check_lda
75: | >ora_getcursor
76: | | entry: ora_getcursor(void)
77: | | exit: returning 0x40013b88
78: | <ora_getcursor
79: | >count_colons
80: | | entry: count_colons("insert into primes values(:1)")
81: | | exit: count_colons: returning 1
82: | <count_colons
83: | info: statement contains 1 colons
84: | info: statement returns no data
85: | exit: returning csr "0x40013b88"
86: <ora_open
87: >ora_bind
88: | entry: ora_bind(0x40013b88, 0x40013e68, 1)
89: | >check_csr
90: | | entry: check_csr(0x40013b88)
91: | | >ora_findcursor
92: | | | entry: ora_findcursor(0x40013b88)
93: | | | exit: is a cursor
94: | | <ora_findcursor
95: | | exit: is a csr
96: | <check_csr
97: | info: obndrn 1, "2" OK
98: | info: 1 rows processed
99: | exit: returning 1
100: <ora_bind
101: >ora_bind
102: | entry: ora_bind(0x40013b88, 0x40013e68, 1)
103: | >check_csr
104: | | entry: check_csr(0x40013b88)
105: | | >ora_findcursor
106: | | | entry: ora_findcursor(0x40013b88)
107: | | | exit: is a cursor
108: | | <ora_findcursor
109: | | exit: is a csr
110: | <check_csr
111: | info: obndrn 1, "3" OK
112: | info: 1 rows processed
113: | exit: returning 1
114: <ora_bind
115: >ora_bind
116: | entry: ora_bind(0x40013b88, 0x40013e68, 1)
117: | >check_csr
118: | | entry: check_csr(0x40013b88)
119: | | >ora_findcursor
120: | | | entry: ora_findcursor(0x40013b88)
121: | | | exit: is a cursor
122: | | <ora_findcursor
123: | | exit: is a csr
124: | <check_csr
125: | info: obndrn 1, "5" OK
126: | info: 1 rows processed
127: | exit: returning 1
128: <ora_bind
129: >ora_bind
130: | entry: ora_bind(0x40013b88, 0x40013e68, 1)
131: | >check_csr
132: | | entry: check_csr(0x40013b88)
133: | | >ora_findcursor
134: | | | entry: ora_findcursor(0x40013b88)
135: | | | exit: is a cursor
136: | | <ora_findcursor
137: | | exit: is a csr
138: | <check_csr
139: | info: obndrn 1, "7" OK
140: | info: 1 rows processed
141: | exit: returning 1
142: <ora_bind
143: >ora_bind
144: | entry: ora_bind(0x40013b88, 0x40013ce8, 1)
145: | >check_csr
146: | | entry: check_csr(0x40013b88)
147: | | >ora_findcursor
148: | | | entry: ora_findcursor(0x40013b88)
149: | | | exit: is a cursor
150: | | <ora_findcursor
151: | | exit: is a csr
152: | <check_csr
153: | info: obndrn 1, "11" OK
154: | info: 1 rows processed
155: | exit: returning 1
156: <ora_bind
157: >ora_commit
158: | entry: ora_commit(0x40013508)
159: | >check_lda
160: | | entry: check_lda(0x40013508)
161: | | >ora_findcursor
162: | | | entry: ora_findcursor(0x40013508)
163: | | | exit: is a cursor
164: | | <ora_findcursor
165: | | exit: is an lda
166: | <check_lda
167: | exit: returning OK
168: <ora_commit
169: >ora_bind
170: | entry: ora_bind(0x40013b88, 0x40013e28, 1)
171: | >check_csr
172: | | entry: check_csr(0x40013b88)
173: | | >ora_findcursor
174: | | | entry: ora_findcursor(0x40013b88)
175: | | | exit: is a cursor
176: | | <ora_findcursor
177: | | exit: is a csr
178: | <check_csr
179: | info: obndrn 1, "13" OK
180: | info: 1 rows processed
181: | exit: returning 1
182: <ora_bind
183: >ora_bind
184: | entry: ora_bind(0x40013b88, 0x40013e28, 1)
185: | >check_csr
186: | | entry: check_csr(0x40013b88)
187: | | >ora_findcursor
188: | | | entry: ora_findcursor(0x40013b88)
189: | | | exit: is a cursor
190: | | <ora_findcursor
191: | | exit: is a csr
192: | <check_csr
193: | info: obndrn 1, "17" OK
194: | info: 1 rows processed
195: | exit: returning 1
196: <ora_bind
197: >ora_bind
198: | entry: ora_bind(0x40013b88, 0x40013e28, 1)
199: | >check_csr
200: | | entry: check_csr(0x40013b88)
201: | | >ora_findcursor
202: | | | entry: ora_findcursor(0x40013b88)
203: | | | exit: is a cursor
204: | | <ora_findcursor
205: | | exit: is a csr
206: | <check_csr
207: | info: obndrn 1, "19" OK
208: | info: 1 rows processed
209: | exit: returning 1
210: <ora_bind
211: >ora_bind
212: | entry: ora_bind(0x40013b88, 0x40013e28, 1)
213: | >check_csr
214: | | entry: check_csr(0x40013b88)
215: | | >ora_findcursor
216: | | | entry: ora_findcursor(0x40013b88)
217: | | | exit: is a cursor
218: | | <ora_findcursor
219: | | exit: is a csr
220: | <check_csr
221: | info: obndrn 1, "23" OK
222: | info: 1 rows processed
223: | exit: returning 1
224: <ora_bind
225: >ora_bind
226: | entry: ora_bind(0x40013b88, 0x40013e28, 1)
227: | >check_csr
228: | | entry: check_csr(0x40013b88)
229: | | >ora_findcursor
230: | | | entry: ora_findcursor(0x40013b88)
231: | | | exit: is a cursor
232: | | <ora_findcursor
233: | | exit: is a csr
234: | <check_csr
235: | info: obndrn 1, "29" OK
236: | info: 1 rows processed
237: | exit: returning 1
238: <ora_bind
239: >ora_close
240: | entry: ora_close(0x40013b88)
241: | >check_csr
242: | | entry: check_csr(0x40013b88)
243: | | >ora_findcursor
244: | | | entry: ora_findcursor(0x40013b88)
245: | | | exit: is a cursor
246: | | <ora_findcursor
247: | | exit: is a csr
248: | <check_csr
249: | >ora_dropcursor
250: | | entry: ora_dropcursor(0x40013b88)
251: | | exit: completed
252: | <ora_dropcursor
253: | exit: returning OK
254: <ora_close
creating table 2 3 5 7 11 committing OK 13 17 19 23 29
Reading table for the first time
255: >ora_open
256: | entry: ora_open(0x40013508, "select prime from primes", 5)
257: | >check_lda
258: | | entry: check_lda(0x40013508)
259: | | >ora_findcursor
260: | | | entry: ora_findcursor(0x40013508)
261: | | | exit: is a cursor
262: | | <ora_findcursor
263: | | exit: is an lda
264: | <check_lda
265: | >ora_getcursor
266: | | entry: ora_getcursor(void)
267: | | exit: returning 0x40013b88
268: | <ora_getcursor
269: | >count_colons
270: | | entry: count_colons("select prime from primes")
271: | | exit: count_colons: returning 0
272: | <count_colons
273: | info: statement contains 0 colons
274: | info: statement returns 1 fields
275: | info: Field 0, length 40, type 2 (number)
276: |
...
read more »