calling stored procs from reports

[Christi]

can someone please tell me how to use trigger to call stored procedure in Oracle reports.
for instance, i have a stored proc called get_emp_no.
How can I write a trigger in Oracle Reports to call this procedure?
thank you very much
C.

 

[gbaliga]

just call the procedure with parameters. Email me if you have any question on this.

 

[KuldeepDongre]

Call the procedure in the after form trigger of the report or the before report trigger.

Call the procedure with the parameters..as usual..