Forum Stats

  • 3,827,643 Users
  • 2,260,802 Discussions
  • 7,897,323 Comments

Discussions

Calling stored procedure into Crystal Report

Could any one help in suggesting how to call the stored procedure with parameters into crystal report?

i have tried using couple of methods

I have added this in add command option of Crystal report
Execute HRMS_DEVP.DPRC_GET_LEAVE_BAL(P_COMP_CODE,P_EMP_CODE,P_LV_CATG_CODE,P_DATE,P_BALANCE)

WHERE in p_balance i would be retrieving the output.

Second method i followed is

SELECT DFUN_GET_LEAVE_BAL(:P_COMP_CODE,:P_EMP_CODE,:P_LV_CATG_CODE,:P_DATE)FROM
DUAL;
This discussion has been closed.