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 -> Assigning columns of each row to variables..

Assigning columns of each row to variables..

From: jegatheesan <jegatheesan_a_at_yahoo.com>
Date: Tue, 10 Aug 1999 10:00:56 GMT
Message-ID: <sLSr3.16702$J5.183453@c01read02-admin.service.talkway.com>


Dear Sir,
  My coding is like

CREATE OR REPLACE PROCEDURE insert_master(nmap number) IS
cursor_handle INTEGER;
insert_count INTEGER;
c integer;
return_value NUMBER(2);
BEGIN
  cursor_handle:=DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(cursor_handle,'select * from employee',DBMS_SQL.NATIVE);
  insert_count:=DBMS_SQL.EXECUTE(cursor_handle);   c:=DBMS_SQL.FETCH_ROWS(cursor_handle);

  DBMS_SQL.CLOSE_CURSOR(cursor_handle); END; In employee table the fields are

   name,age,sex
I want to get each record with looping and assinging the name to one variable,age to one variable and sex to one variable. How to do that?
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Tue Aug 10 1999 - 05:00:56 CDT

Original text of this message

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