ora_fetch() - Error ORA-01002: fetch out of sequence 
Author Message
 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 »



Sat, 19 Jul 1997 02:59:27 GMT  
 ora_fetch() - Error ORA-01002: fetch out of sequence

Quote:

>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

IF you're up to date with the contents of
        ftp.demon.co.uk:/pub/perl/db/perl4/oraperl
then I can't help. Sorry.

*Please* let me know what you and Kevin come up with so I can put it
in the archive.

Regards,
Tim Bunce.



Sat, 19 Jul 1997 18:04:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ORA-01002 "fetch out of sequence" error with ORAPERL

2. 'fetch out of sequence' error

3. Oraperl Error: "fetch out of sequence"

4. Perl Oracle DBD with NLS_LANG UTF8 getting errors ORA-01406 ORA-24345

5. Oracle err 01002

6. fetch: a swissprot sequence retrieval program

7. using DBI , unreasonable conversion error - ORA-01460

8. using DBI,unreasonable conversion error-ORA 01460

9. Unreasonable conversion . ERROR ORA-001460

10. DBI error: ORA-06401: NETCMN: invalid driver designator

11. Pod errors: Unterminated S<...> sequence

12. Error oraperl <=> Oracle 7.1 fetch out of sequence

 

 
Powered by phpBB® Forum Software