Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date related error

User_T57AFFeb 16 2023

I create A procedure to Insert Data in database from Oracle Apex Front end , but when I try to save the data it shows an error

my procedure is:

================

create or replace PROCEDURE PURCHASE_PROC (

P_PUR_DATE IN VARCHAR2,

P_SUPPLIER IN NUMBER

)

IS

V_PUR_ID NUMBER:= 0;

BEGIN

BEGIN

SELECT NVL(MAX(PUR_ID),0)+1 INTO V_PUR_ID

FROM PURCHASE;

END;

IF V_PUR_ID > 0 THEN

INSERT INTO PURCHASE (

PUR_ID,

PUR_DATE,

SUPPLIER_ID,

CREATED_BY,

CREATED_DATE

)

VALUES (

V_PUR_ID,

TO_DATE(P_PUR_DATE,'DD/MM/RRRR'),

P_SUPPLIER,

USER,

SYSDATE

);

commit;

END IF;

END;

Error is

======

Technical Info (only available for developers)

  • is_internal_error: false
  • original_additional_info: ORA-01843: not a valid month
  • ora_sqlcode: -1843
  • ora_sqlerrm: ORA-01843: not a valid month ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "WKSP_SOHELJU.PURCHASE_PROC", line 13 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163
  • component.type: APEX_APPLICATION_PAGE_PROCESS
  • component.id: 52197953560837433711
  • component.name: Save
  • error_backtrace:
    ORA-06512: at "WKSP_SOHELJU.PURCHASE_PROC", line 13 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "WKSP_SOHELJU.PURCHASE_PROC", line 13 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS", line 170
  • error_statement:
    begin begin PURCHASE_PROC ( P_PUR_DATE => (to_date(:P2_P_DATE, 'MM/DD/YYYY')), P_SUPPLIER => :P2_SUP_ID ); end; end;
Comments
Post Details
Added on Feb 16 2023
1 comment
65 views