Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL table next function, Oracle 7 vs Oracle 8

PL/SQL table next function, Oracle 7 vs Oracle 8

From: Francis Small <fthes_at_sr.hp.com>
Date: 7 May 1999 21:00:17 GMT
Message-ID: <7gvk91$snu@canyon.sr.hp.com>


Is there any reason why the following statement would work just fine in Oracle 7, but appears to hang in Oracle 8:

 rec_id := lock_tab.next(rec_id);

Appropriate definitions:

  type lock_id_rectype is record (
     select_ckp natural,   -- select checkpoint
     modify_ckp natural,   -- modification checkpoint
     delete_ckp natural,   -- create/delete checkpoint
     reserve_ckp natural); -- check out checkpoint
  

  type lock_id_tabtype is table of lock_id_rectype     index by binary_integer;

  lock_tab lock_id_tabtype;

Thanks. I'm currently stumped.

  Francis

--
. . .|. . 5 . . . . 10. . . . 15. . . . 20. . . . 25. . . . 30. . . . 35. . .

Giants                                         Francis Small - M/S M1RA     
 Bums                                            Test Engineering
    Diamondbacks                                   Microwave Instruments Div.
       Rockies                                       telnet 794-3305
            Padres                                     fthes_at_sr.hp.com
*********************** National League West Standings ***********************
Received on Fri May 07 1999 - 16:00:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US