Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL table next function, Oracle 7 vs Oracle 8
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
![]() |
![]() |