The received the following error when I was trying to create a new proceder in APEX. Here is my code that I was attempting to add and the table details below, and assistance will be greatly appreciated.
BEGIN
P_UPDATE(:P3_SCANNED_BY, :P3_SCANNED_DATE_TIME, :P3_SCANNED_DATE, :P3_MANUALLY_ADDED );
INSERT INTO DELL_OH_ICPI(DOI_SCANNED_BY, DOI_SCANNEDBY_DATETIME, DOI_SCANNEDBY_DATE, DOI_MANUALLY_ADDED)
VALUES(:APP_USER, systimestamp, sysdate, :P3_MANUALLY_ADDED);
COMMIT;
END;
And here are the tables
"Column Name","Data Type","Nullable","Default","Primary Key"
"DOI_DELL_LP","VARCHAR2(50)","No","","1"
"DOI_TIME","TIMESTAMP(6)","Yes","",""
"DOI_DATE","DATE","Yes","",""
"DOI_DELLPARTNUM","VARCHAR2(20)","Yes","",""
"DOI_PPID","VARCHAR2(100)","Yes","",""
"DOI_DISPOSITION","VARCHAR2(100)","Yes","",""
"DOI_FAMILY","VARCHAR2(100)","Yes","",""
"DOI_DESCRIPTION","VARCHAR2(100)","Yes","",""
"DOI_BLSTATUS","VARCHAR2(25)","Yes","",""
"DOI_PRODUCT","VARCHAR2(100)","Yes","",""
"DOI_CONTAINER_ID","VARCHAR2(100)","Yes","",""
"DOI_PALLET_ID","VARCHAR2(100)","Yes","",""
"DOI_LOCATION","VARCHAR2(100)","Yes","",""
"DOI_DELL_COST","NUMBER","Yes","",""
"DOI_SCANNED_BY","VARCHAR2(100)","Yes","",""
"DOI_SCANNEDBY_DATETIME","TIMESTAMP(6)","Yes","",""
"DOI_SCANNEDBY_DATE","DATE","Yes","",""
"DOI_MANUALLY_ADDED","VARCHAR2(10)","Yes","",""