Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Assigning columns of each row to variables..
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