SQL Developer

Hi All,

I am having a problem with dates, scripts and the debugger.

I have a procedure that takes a date value as an in_variable.

procedure_x(in_date date)

I usually call this procedure from a script.

select to_date(my_date,'mm/dd/yyyy') into my_var from my table;

proc_x(my_var);


I have set sql developer to run scripts from a specific folder.

So i just type in @runscript.sql

When i do this everything runs perfectly fine.

When I try to debug this procedure by clicking on the debug(inside edit mode) --> run from file

It always returns a date error. 'ORA-01843: not a valid month'

I have noticed in the debugger the date format for some reason defaults to 06-12-01 00:00:00.

I have my nls_date format set to 'MM/DD/YYYY' in the preferences ...

Anybody know what the difference is? I am using the same file and it works when i execute it as an sql script but not when i use the run from file option

Is this a bug in the newest release?

Thanks in advance ...