| 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
![]() |
![]() |