7 Replies Latest reply: Feb 19, 2013 12:40 AM by V11081985 RSS

    How to view SYS_REFCURSOR output parameters in TOAD

    V11081985
      Hi Team,

      Here is my procedure which was compiled succesfully...

      procedure SLA_FAILURE_PR_SR(
      startdate_i IN DATE,
      enddate_i IN DATE,
      pacifictimezone_i IN VARCHAR2,
      extranet_user_i IN VARCHAR2,
      severity_i IN NUMBER,
      reportRC_o out sys_refcursor
      )
      IS
      BEGIN
      logpkg.info ('Begin ramOpsReportSummaryPkg.SLA_FAILURE_PR_SR');
      open reportRC_o for
      SELECT
      customer "Client",
      case_id_ "Case ID",
      to_char(aradmin.datepkg.unixTimeToDate(create_time, 'PST', 'Y'),'MM-DD-YYYY HH12:MI:SS PM') "Created",
      to_char(aradmin.datepkg.unixTimeToDate(resolved_time, 'PST', 'Y'),'MM-DD-YYYY HH12:MI:SS PM') "Resolved",
      total_downtime__min_ "Down Time",
      assigned_to_group_ || ' ' || ASSIGNED_TO_INDIVIDUAL_ "Group Assigned",
      reason_for_missed_sla "Reason For Miss",
      assigned_to_group_ "Group That Missed",
      internal_mgmt_summary "Ops Mgmt summary",
      follow_up_proactive_actions "Follow-Up Proactive Actions"
      FROM aradmin.hpd_helpdesk
      WHERE
      create_time >= datepkg.dateToUnixTime(TO_DATE(startdate_i,'YYYY-MM-DD'),pacifictimezone_i)
      AND create_time < datepkg.dateToUnixTime(TO_DATE(enddate_i,'YYYY-MM-DD')+7,pacifictimezone_i)
      AND extranet_user=extranet_user_i
      AND severity = severity_i
      AND (MET_RESOLUTION_SLA_=0 or MET_CONTACT_SLA_=0);

      logpkg.info ('END ramOpsReportSummaryPkg.SLA_FAILURE_PR_SR');

      END SLA_FAILURE_PR_SR;

      --The query inside cursor is fetching results. but i couldnt get the results when i executed whole procedure.
      -- Can anyone help on this and give me the procedure how to execute it in toad. I am using oracle 10g and Toad 9.6 versions.