function CreateInvoice( pNumber varchar2, pErrorMessage out varchar2 ) return number is cursor c_sets( pLief_sch_nr varchar2 ) is select * from table where lief_sch_nr = pLief_sch_nr and c_px = 1 ; pc_sets c_sets%rowtype; begin ... open c_sets( pNumber ); loop fetch c_sets into pc_sets; exit when c_sets%notfound; ... end loop; close c_sets;
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Thursday, January 25, 2018
ORACLE - How make PL/SQL cursor with parameter(s)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment