davegauthier
Member
Hi:
I'd like to use Query Reporter to execute PL/SQL which returns a ref cursor. Moreover, I'd like to be able to pass query predicate search criteria into the PL/SQL via a GUI. The resulting functionality would be similar to running a test script under PL/SQL Developer (declare variables, set their values, execute the PL/SQL, "print" results). But I would like the GUI which prompts users for input prior to the run.
The PL/SQL returns a ref cursor. "print"ing the ref cursor should allow for printing many records.
Can you do it?
I'd like to use Query Reporter to execute PL/SQL which returns a ref cursor. Moreover, I'd like to be able to pass query predicate search criteria into the PL/SQL via a GUI. The resulting functionality would be similar to running a test script under PL/SQL Developer (declare variables, set their values, execute the PL/SQL, "print" results). But I would like the GUI which prompts users for input prior to the run.
The PL/SQL returns a ref cursor. "print"ing the ref cursor should allow for printing many records.
Can you do it?
