tag:blogger.com,1999:blog-2132893136140848212.post8993789105296330013..comments2023-09-09T03:03:30.219-06:00Comments on Martin Giffy D'Souza on Oracle APEX: Logger 2.1.0 - 10g Sequence FixedMartin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2132893136140848212.post-87640536679810104552013-08-11T21:34:38.279-06:002013-08-11T21:34:38.279-06:00Hi Sean,
I did look at doing that but decided aga...Hi Sean,<br /><br />I did look at doing that but decided against it for this version since it really had no impact in the end (see Connor's article above). If the internal works of nextval has been changed in 12c then we'll look at changing it for the performance gain.<br /><br />Thanks,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-33973932121815418032013-08-09T10:02:09.661-06:002013-08-09T10:02:09.661-06:00you could try conditional compilation
$IF DBMS_DB...you could try conditional compilation<br /><br />$IF DBMS_DB_VERSION.ver_le_11_1<br />$THEN<br /> SELECT logger_logs_seq.NEXTVAL INTO :new.id FROM DUAL;<br />$ELSE<br /> :new.id := logger_logs_seq.NEXTVAL;<br />$END<br /><br />but this would limit to 10gR2 and higherAnonymousnoreply@blogger.com