Relative Content

Tag Archive for oracle-databasefunctionplsqlsys-refcursorref-cursor

Outer function returning multi-line values with the help of refcursors

I’m learning ref cursors, record type concepts.
Below is the logic I’m trying [I kn which is wrong at few lines],
On high level, Outer function ‘get_modified_ssd_rsd2’ has order number as one of parameter [with multiple lines under it], where one by one line_ids are passed to inner function. ‘get_modified_ssd_rsd1’ which is inner function returning 2dates in refcursors. It is tested successfully. I’m trying/ask is,
how can I return orderno, lineid, date1,date2 – four parameters via outer function [i.e. get_modified_ssd_rsd2] in refcursor?