5 Replies Latest reply on Feb 19, 2015 4:31 PM by jmarton

    call a stored procedure from SQL developer UI

    ANNEC

      I have a stored procedure created that has a date in parameter.

       

      Then I tried to run it from SQL developer by right click the stored procedure, and then it comes out a parameter window, and I tried to enter the value in the input value field, by entering '01-JAN-2015' for I know our date format of the server is DD-MON-RR.

      But it shows a wrong format window: please use yyyy-MM-dd date format,

       

      Why is that?

       

      The generated code from SQL developer  is below after I input '2015-01-01'

       

      DECLARE
        P_DATESTORED DATE;
      BEGIN
        P_DATESTORED := to_date('2015-01-01','yyyy-MM-dd');

        MySproc (
          P_DATESTORED => P_DATESTORED
        );
      --rollback;
      END;

       

      Can I simply use below: for the date format of the server is DD-MON-RR.

       

      Begin

      MySproc('01-JAN-2015')

      End;

       

      Thanks,

      We are using oracle 11g 2, window enviroment.