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

Home -> Community -> Usenet -> c.d.o.misc -> Cursors

Cursors

From: Dan Fluet <dfluet_at_bdsinc.com>
Date: Thu, 19 Aug 1999 12:57:52 -0400
Message-ID: <37BC3790.F26B0FEC@bdsinc.com>


Is there anyway to print out to the screen from the middle of a cursor. I know how to do it using SQL Server but I can't seem to do it in Oracle

code included

create or replace procedure DAN
AS
BEGIN
declare
 cursor sq_cursor is select * from daily_sales order by sale_qty desc;  sq_val sq_cursor%ROWTYPE;

    i INTEGER(5);
begin

    open sq_cursor;
 for i in 1..10 loop
  fetch sq_cursor into sq_val;
/** I WOULD LIKE TO print sq_val.ean_no HERE**/   exit when sq_cursor%NOTFOUND;
 end loop;
 close sq_cursor;
end;
END; Received on Thu Aug 19 1999 - 11:57:52 CDT

Original text of this message

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