Originally posted by tamilselvan
INSERT INTO table_B from cursor....

What is this?

Tamil
if l_request_id is NULL
then
insert into table_B
( REQUEST_ID,
REQUESTED_BY,
PHASE_CODE,
STATUS_CODE,
PROGRAM_APPLICATION_ID,
CONCURRENT_PROGRAM_ID,
NUMBER_OF_COPIES,
PRINTER,
DESCRIPTION,
ACTUAL_COMPLETION_DATE,
ARGUMENT_TEXT)
values
(cr.REQUEST_ID,
cr.REQUESTED_BY,
cr.PHASE_CODE,
cr.STATUS_CODE,
cr.PROGRAM_APPLICATION_ID,
cr.CONCURRENT_PROGRAM_ID,
cr.NUMBER_OF_COPIES,
cr.PRINTER,
cr.DESCRIPTION,
cr.ACTUAL_COMPLETION_DATE,
cr.ARGUMENT_TEXT);
end if;