Print Thread
Issue with DATE variable in debug
#30805 09/30/08 02:13 AM
Joined: Sep 2008
Posts: 2
SoCal
K
Keehan Offline OP
Member
OP Offline
Member
K
Joined: Sep 2008
Posts: 2
SoCal
/*I have submitted this to support, but hoping someone on here might have a quick answer.*/

I am a brand new user of PL/SQL Developer. I have just gotten started debugging on a legacy procedure. I am witnessing something that seems wrong or broken.

I have a procedure that is replicating data from one database to another. I get the next start time, v_StartTime by (get last endtime, add 1 second (in days)):

SELECT endtime
INTO v_StartTime
FROM LU_REPLICATION_CONTROL
WHERE procedurename = v_ProcName;

v_StartTime := v_StartTime + 1 / (24 * 60 * 60);

INSERT INTO lu_sch_log
(PROCEDURENAME, STARTTIME, ENDTIME, SP_ST, SP_ET, TIMESTAMP)
VALUES
(v_ProcName,
v_StartTime,
v_EndTime,
process_start,
SYSDATE,
SYSDATE);

When I look at the value of v_StartTime during debug, I see

Re: Issue with DATE variable in debug
#30806 09/30/08 04:47 AM
Joined: Sep 2008
Posts: 2
SoCal
K
Keehan Offline OP
Member
OP Offline
Member
K
Joined: Sep 2008
Posts: 2
SoCal
It seems like a separate setting for the DATE FORMAT is required for the debugger? I found the DATE and TIME FORMAT options for the UI, but this did not seem to affect variables seen during debugging.

Keehan

Re: Issue with DATE variable in debug
#30807 09/30/08 12:37 PM
Joined: Mar 2007
Posts: 210
Rostock, Germany
Member
Offline
Member
Joined: Mar 2007
Posts: 210
Rostock, Germany
Hi,

search for "debug date format" in this forum smile
and you'll find some topics like

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=005327

with this hint from Marko.

Code
begin
    -- Modify the nls_date_format for the session of the test script
    dbms_session.set_nls('nls_date_format','''DD-MM-YYYY HH24:MI:SS''');
    -- Run the procedure
    xyz(p1 => :p1, p2 => :p2);
  end;
HTH


There is no shortcut for experience(d).

PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300
Oracle 11g,12c
Windows Server 2003/2008
Windows 10 Professionel 64 bit




Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4