call a function to return a cursor

[Roger Gilliar]

I would like to call a PL/SQL function to return a cursor. The idea is to pass some arguments to this function and depending on this arguments I want to return a resultset that can be shown in a dbGrid control. Is this possible ?

Regards
Roger

 

[Marco Kalter]

Yes, this is possible. The PkgApply example project demonstrates this. It uses a cursor variable that returns employees, and as input it takes the department number and a sort column.

------------------
Marco Kalter
Allround Automations