Bi-Directional Cursors Now Available

Bi-Directional PL/SQL Cursors Available

Bi-directional cursors - cursors which can read forward and backward through a result set - are not supported in native PL/SQL. But bi-directional cursor access to your Oracle data can now be achieved with PL/Vision, a software library of PL/SQL packages that supply drop-in program logic.

Full details are available at the RevealNet website (http://www.revealnet.com), or call (800) 738-3254 or E-mail info_at_revealnet.com

Consider the following code fragment:

DECLARE
   curid INTEGER;
BEGIN
   curid := PLVrep.dbtabid

      ('SELECT ename, sal FROM emp', bidir => TRUE);    PLVrep.getall (curid);

I define a database table repository based on the virtual table represented by the SELECT statement. I also specify that I want this respository to be bi-directional. I then call the getall procedure to open the cursor and retrieve all rows.

Now I can move to whatever row I want within the result set, including the first:

   PLVrep.get (curid, 1);

I can also navigate sequentially to next or previous records retrieved with calls like
these:

   PLVrep.getnext (curid);
   PLVrep.getprev (curid);

PL/Vision is a software library of PL/SQL packages that supply drop-in program logic. Instead of coding thousands of lines of complex PL/SQL code, just execute a PL/Vision package and let it to do the work.

Developed by the world renowned PL/SQL author Steven Feuerstein, PL/Vision’s application building blocks can revolutionize the way you develop Oracle applications.

Best wishes,

Cam White
RevealNet, Inc. Received on Wed Mar 19 1997 - 00:00:00 CET