13-Vas-2007 18:05:07: [Describe(2)]

13-Vas-2007 18:05:07: SQL: DECLARE
"Return Value" VARCHAR2(4000);
TYPE CURSOR_TYPE_1 IS REF CURSOR;
p_statistics_cursor CURSOR_TYPE_1;
BEGIN

  "Return Value" := monitoring.set_monitoring_nls_format('.',   ',',  'YYYY.MM.DD HH24:MI:SS', 'YYYY.MM.DD HH24:MI:SS', 'YYYY.MM.DD', 'HH24:MI:SS');

-- Output the results
dbms_output.put_line(SubStr('"Return Value" = '||"Return Value",1,255));

-- Now call the stored program
  "Return Value" := monitoring.get_statistics_history_report(SYSDATE-365,SYSDATE,p_statistics_cursor);

-- Output the results
dbms_output.put_line(SubStr('"Return Value" = '||"Return Value",1,255));
-- Unknown cursor return type
-- If required, edit code to display cursor output

EXCEPTION
WHEN OTHERS THEN
  dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
RAISE;
END;

13-Vas-2007 18:05:07: [Executing(2)] SQL: DECLARE
"Return Value" VARCHAR2(4000);
TYPE CURSOR_TYPE_1 IS REF CURSOR;
p_statistics_cursor CURSOR_TYPE_1;
BEGIN

  "Return Value" := monitoring.set_monitoring_nls_format('.',   ',',  'YYYY.MM.DD HH24:MI:SS', 'YYYY.MM.DD HH24:MI:SS', 'YYYY.MM.DD', 'HH24:MI:SS');

-- Output the results
dbms_output.put_line(SubStr('"Return Value" = '||"Return Value",1,255));

-- Now call the stored program
  "Return Value" := monitoring.get_statistics_history_report(SYSDATE-365,SYSDATE,p_statistics_cursor);

-- Output the results
dbms_output.put_line(SubStr('"Return Value" = '||"Return Value",1,255));
-- Unknown cursor return type
-- If required, edit code to display cursor output

EXCEPTION
WHEN OTHERS THEN
  dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
RAISE;
END;

13-Vas-2007 18:05:08: [Executing(1)] SQL: DECLARE 
  ctx dbms_debug.runtime_info; 
  timeout BINARY_INTEGER; 
BEGIN 
  timeout := dbms_debug.set_timeout(2); 
  :P_status := dbms_debug.synchronize(ctx,14); 
  :P_LineNo := ctx.line#; 
  :P_terminated := ctx.terminated; 
  :P_BreakPoint := ctx.BreakPoint; 
  :P_Stackdepth := ctx.stackDepth; 
  :P_Unitnamespace := ctx.program.namespace; 
  :P_reason := ctx.reason; 
  :P_Unitname := ctx.program.name; 
  :P_Unitowner := ctx.program.owner; 
  :P_Unitdblink := ctx.program.dblink; 
  timeout := dbms_debug.set_timeout(0); 
END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=2

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [Executing(1)] SQL:  BEGIN 
   dbms_debug.print_backtrace ( :P_STACKLINES );  
 END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_STACKLINES= <source not available>

13-Vas-2007 18:05:08: [SetVariable(1)]:P_DEBUG_FLAGS=0

13-Vas-2007 18:05:08: [Executing(1)] SQL:  DECLARE 
   rinfo dbms_debug.runtime_info;  
 BEGIN 
  :P_status := dbms_debug.continue(rinfo,:P_DEBUG_FLAGS,255); 
  :P_LineNo := rinfo.line#; 
  :P_terminated := rinfo.terminated; 
  :P_BreakPoint := rinfo.BreakPoint;  
  :P_Stackdepth := rinfo.stackDepth; 
  :P_Unitnamespace := rinfo.program.namespace; 
  :P_reason := rinfo.reason;  
  :P_Unitname := rinfo.program.name; 
  :P_Unitowner := rinfo.program.owner;  
  :P_Unitdblink := rinfo.program.dblink;  
  :P_oer := rinfo.oer;
 END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=1

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=25

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_oer=0

13-Vas-2007 18:05:08: [Executing(2)] SQL:  BEGIN 
   DBMS_OUTPUT.GET_LINE(:LINE,:STATUS); 
 END;

13-Vas-2007 18:05:08: [Executing(1)] SQL: DECLARE 
  ctx dbms_debug.runtime_info; 
  timeout BINARY_INTEGER; 
BEGIN 
  timeout := dbms_debug.set_timeout(2); 
  :P_status := dbms_debug.synchronize(ctx,14); 
  :P_LineNo := ctx.line#; 
  :P_terminated := ctx.terminated; 
  :P_BreakPoint := ctx.BreakPoint; 
  :P_Stackdepth := ctx.stackDepth; 
  :P_Unitnamespace := ctx.program.namespace; 
  :P_reason := ctx.reason; 
  :P_Unitname := ctx.program.name; 
  :P_Unitowner := ctx.program.owner; 
  :P_Unitdblink := ctx.program.dblink; 
  timeout := dbms_debug.set_timeout(0); 
END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=2

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [SetVariable(1)]:P_DEBUG_FLAGS=0

13-Vas-2007 18:05:08: [Executing(1)] SQL:  DECLARE 
   rinfo dbms_debug.runtime_info;  
 BEGIN 
  :P_status := dbms_debug.continue(rinfo,:P_DEBUG_FLAGS,255); 
  :P_LineNo := rinfo.line#; 
  :P_terminated := rinfo.terminated; 
  :P_BreakPoint := rinfo.BreakPoint;  
  :P_Stackdepth := rinfo.stackDepth; 
  :P_Unitnamespace := rinfo.program.namespace; 
  :P_reason := rinfo.reason;  
  :P_Unitname := rinfo.program.name; 
  :P_Unitowner := rinfo.program.owner;  
  :P_Unitdblink := rinfo.program.dblink;  
  :P_oer := rinfo.oer;
 END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=1

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=25

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_oer=0

13-Vas-2007 18:05:08: [GetVariable(2)]:STATUS=0

13-Vas-2007 18:05:08: [GetVariable(2)]:LINE="Return Value" =

13-Vas-2007 18:05:08: [Executing(2)] SQL:  BEGIN 
   DBMS_OUTPUT.GET_LINE(:LINE,:STATUS); 
 END;

13-Vas-2007 18:05:08: [Executing(1)] SQL: DECLARE 
  ctx dbms_debug.runtime_info; 
  timeout BINARY_INTEGER; 
BEGIN 
  timeout := dbms_debug.set_timeout(2); 
  :P_status := dbms_debug.synchronize(ctx,14); 
  :P_LineNo := ctx.line#; 
  :P_terminated := ctx.terminated; 
  :P_BreakPoint := ctx.BreakPoint; 
  :P_Stackdepth := ctx.stackDepth; 
  :P_Unitnamespace := ctx.program.namespace; 
  :P_reason := ctx.reason; 
  :P_Unitname := ctx.program.name; 
  :P_Unitowner := ctx.program.owner; 
  :P_Unitdblink := ctx.program.dblink; 
  timeout := dbms_debug.set_timeout(0); 
END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=2

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [SetVariable(1)]:P_DEBUG_FLAGS=0

13-Vas-2007 18:05:08: [Executing(1)] SQL:  DECLARE 
   rinfo dbms_debug.runtime_info;  
 BEGIN 
  :P_status := dbms_debug.continue(rinfo,:P_DEBUG_FLAGS,255); 
  :P_LineNo := rinfo.line#; 
  :P_terminated := rinfo.terminated; 
  :P_BreakPoint := rinfo.BreakPoint;  
  :P_Stackdepth := rinfo.stackDepth; 
  :P_Unitnamespace := rinfo.program.namespace; 
  :P_reason := rinfo.reason;  
  :P_Unitname := rinfo.program.name; 
  :P_Unitowner := rinfo.program.owner;  
  :P_Unitdblink := rinfo.program.dblink;  
  :P_oer := rinfo.oer;
 END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=1

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=25

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_oer=0

13-Vas-2007 18:05:08: [GetVariable(2)]:STATUS=0

13-Vas-2007 18:05:08: [GetVariable(2)]:LINE="Return Value" =

13-Vas-2007 18:05:08: [Executing(2)] SQL:  BEGIN 
   DBMS_OUTPUT.GET_LINE(:LINE,:STATUS); 
 END;

13-Vas-2007 18:05:08: [Executing(1)] SQL: DECLARE 
  ctx dbms_debug.runtime_info; 
  timeout BINARY_INTEGER; 
BEGIN 
  timeout := dbms_debug.set_timeout(2); 
  :P_status := dbms_debug.synchronize(ctx,14); 
  :P_LineNo := ctx.line#; 
  :P_terminated := ctx.terminated; 
  :P_BreakPoint := ctx.BreakPoint; 
  :P_Stackdepth := ctx.stackDepth; 
  :P_Unitnamespace := ctx.program.namespace; 
  :P_reason := ctx.reason; 
  :P_Unitname := ctx.program.name; 
  :P_Unitowner := ctx.program.owner; 
  :P_Unitdblink := ctx.program.dblink; 
  timeout := dbms_debug.set_timeout(0); 
END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=2

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [SetVariable(1)]:P_DEBUG_FLAGS=0

13-Vas-2007 18:05:08: [Executing(1)] SQL:  DECLARE 
   rinfo dbms_debug.runtime_info;  
 BEGIN 
  :P_status := dbms_debug.continue(rinfo,:P_DEBUG_FLAGS,255); 
  :P_LineNo := rinfo.line#; 
  :P_terminated := rinfo.terminated; 
  :P_BreakPoint := rinfo.BreakPoint;  
  :P_Stackdepth := rinfo.stackDepth; 
  :P_Unitnamespace := rinfo.program.namespace; 
  :P_reason := rinfo.reason;  
  :P_Unitname := rinfo.program.name; 
  :P_Unitowner := rinfo.program.owner;  
  :P_Unitdblink := rinfo.program.dblink;  
  :P_oer := rinfo.oer;
 END;

13-Vas-2007 18:05:08: [GetVariable(1)]:P_status=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_LineNo=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_terminated=1

13-Vas-2007 18:05:08: [GetVariable(1)]:P_BreakPoint=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Stackdepth=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_reason=25

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitnamespace=0

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitname=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitowner=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_Unitdblink=

13-Vas-2007 18:05:08: [GetVariable(1)]:P_oer=0

13-Vas-2007 18:05:08: [GetVariable(2)]:STATUS=1