Toad World® Forums

Gettint results in Toad for Oracle Procedure


#1

Hi Team

I have a procedure below

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;

–I have compiled this and executed with the below block

DECLARE
reportRC_o SYS_REFCURSOR;

a number;

BEGIN

ramOpsReportSummaryPkg.SLA_FAILURE_PR_SR(to_date('2013-01-01','YYYY-MM-DD HH:MI:SS'),to_date('2013-01-10','YYYY-MM-DD HH:MI:SS'),'PST',
'totality',1,:reportRC_o);

–dbms_output.put_line();

END;

– I am not getting result set even there is data that meet the criteria. But the procedure is executing successfully. Plz help me in this regard.
Thanks in advance