@VVVV Исправьте свои серверные сценарии, которые анализируют JSON и вызывают процедуру для передачи дат, а не строк.
у обновить свой столбец даты для какой-то цели. Значение, уже сохраненное в столбце, выглядит так, как показано ниже.
18-06-14
и при обновлении. Если я ничего не обновляю, не отлаживаю и не проверяю, он принимает формат как2014-06-18T00:00:00
Таким образом, при обновлении я получаю ошибку, как показано ниже в моей процедуре.
ORA-1843: недействительный месяц
Ниже показано, как я отправляю его в качестве параметра для его обновления.
LAUNCH_DATE = P_LAUNCH_DATE,
вP_LAUNCH_DATE У меня есть значения для обновления. что дает мне вышеуказанную ошибку. Как мне это решить.
ОБНОВИТЬ
Вот весь мой сохраненный способ, которым я его использую.
PROCEDURE INSERT_INTO_RRSOC_MST
(
P_STORE_CODE IN NVARCHAR2,
P_STATE IN NVARCHAR2,
P_CITY IN NVARCHAR2,
P_SITE_STORE_FORMAT IN NVARCHAR2,
P_STORE_SITENAME IN NVARCHAR2,
P_STORE_SITENAME_LANDL_1 IN NVARCHAR2,
P_STORE_SITENAME_LANDL_2 IN NVARCHAR2,
P_STORE_ASST_MANAGER_NAME IN NVARCHAR2,
P_STORE_ASST_MANAGER_MOBNO IN NVARCHAR2,
P_STORE_MANAGER_NAME IN NVARCHAR2,
P_MANAGER_MOBNO IN NVARCHAR2,
P_EMP_NEAREST_STORE IN NVARCHAR2,
P_EMP_NEAREST_STORE_MOBNO IN NVARCHAR2,
P_SUPERVISOR_NAME IN NVARCHAR2,
P_SUPERVISOR_MOBNO IN NVARCHAR2,
P_SECURITY_SUP_NAME_STORE IN NVARCHAR2,
P_SECURITY_SUP_MOBNO_STORE IN NVARCHAR2,
P_NAME_ALIGNED_LPO IN NVARCHAR2,
P_LPO_MOBILENO IN NVARCHAR2,
P_ALPM_ALPO_NAME IN NVARCHAR2,
P_ALPM_ALPO_MOBNO IN NVARCHAR2,
P_AREA_MANAGER_NAME IN NVARCHAR2,
P_AREA_MANAGER_MOBNO IN NVARCHAR2,
P_ZONAL_HEAD_NAME IN NVARCHAR2,
P_ZONAL_HEAD_NO IN NVARCHAR2,
P_DVR_IP_ADDRESS IN NVARCHAR2,
P_SIGNET_IP_ADDRESS IN NVARCHAR2,
P_NEAREST_POLICE_STN_NAME IN NVARCHAR2,
P_NEAREST_POLICE_STN_CONTNO IN NVARCHAR2,
P_NEAREST_HOSP_NAME IN NVARCHAR2,
P_NEAREST_HOSP_CONTNO IN NVARCHAR2,
P_NEAREST_FIRE_STN_CONTNAME IN NVARCHAR2,
P_NEAREST_FIRE_STN_CONTNO IN NVARCHAR2,
P_STORE_ADDRESS IN CLOB,
P_STORE_SPACE_SQFT IN NUMBER,
P_LAUNCH_DATE IN DATE,
P_CST_TIN_NO IN NVARCHAR2,
P_STORE_EMAILID IN NVARCHAR2,
P_NO_OF_POS IN NUMBER,
P_NO_OF_CAMERA IN NUMBER,
P_DVR_MODEL_GESECURITY IN NVARCHAR2,
P_CAMERA_MODEL IN NVARCHAR2,
P_ALIGNED_LPO_MAILDID IN NVARCHAR2,
P_FACILTY_TEAMNAME IN NVARCHAR2,
P_FACILITY_TEAMNO IN NVARCHAR2,
P_STATE_HEAD_OPS_NAME IN NVARCHAR2,
P_STATE_HEAD_OPS_NO IN NVARCHAR2,
P_LPA IN NVARCHAR2,
P_SLP_STATE_HEAD IN NVARCHAR2,
P_SLP_STATE_HEAD_NO IN NVARCHAR2,
P_CREATED_BY IN NVARCHAR2,
P_CREATED_DATE IN DATE,
P_LAST_UPDATED_BY IN NVARCHAR2,
P_LAST_UPDATED_DATE IN DATE,
P_ISACTIVE IN CHAR,
P_LATITUDE IN NUMBER,
P_LONGITUDE IN NUMBER,
TBLDATA OUT NUMBER
)
AS
V_RRSOC_ID NUMBER:=0;
BEGIN
SELECT COUNT(RRSOC_ID) INTO V_RRSOC_ID FROM TBL_RRSOC_STORE_INFO WHERE STORE_CODE = P_STORE_CODE;
IF V_RRSOC_ID > 0 THEN
UPDATE TBL_RRSOC_STORE_INFO
SET
STATE = P_STATE,
CITY = P_CITY,
SITE_STORE_FORMAT = P_SITE_STORE_FORMAT,
STORE_SITENAME = P_STORE_SITENAME,
STORE_SITENAME_LANDL_1 = P_STORE_SITENAME_LANDL_1,
STORE_SITENAME_LANDL_2 = P_STORE_SITENAME_LANDL_2,
STORE_ASST_MANAGER_NAME = P_STORE_ASST_MANAGER_NAME,
STORE_ASST_MANAGER_MOBNO = P_STORE_ASST_MANAGER_MOBNO,
STORE_MANAGER_NAME = P_STORE_MANAGER_NAME,
MANAGER_MOBNO = P_MANAGER_MOBNO,
EMP_NEAREST_STORE = P_EMP_NEAREST_STORE,
EMP_NEAREST_STORE_MOBNO = P_EMP_NEAREST_STORE_MOBNO,
SUPERVISOR_NAME = P_SUPERVISOR_NAME,
SUPERVISOR_MOBNO = P_SUPERVISOR_MOBNO,
SECURITY_SUP_NAME_STORE = P_SECURITY_SUP_NAME_STORE,
SECURITY_SUP_MOBNO_STORE = P_SECURITY_SUP_MOBNO_STORE,
NAME_ALIGNED_LPO = P_NAME_ALIGNED_LPO,
LPO_MOBILENO = P_LPO_MOBILENO,
ALPM_ALPO_NAME = P_ALPM_ALPO_NAME,
ALPM_ALPO_MOBNO = P_ALPM_ALPO_MOBNO,
AREA_MANAGER_NAME = P_AREA_MANAGER_NAME,
AREA_MANAGER_MOBNO = P_AREA_MANAGER_MOBNO,
ZONAL_HEAD_NAME =P_ZONAL_HEAD_NAME,
ZONAL_HEAD_NO = P_ZONAL_HEAD_NO,
DVR_IP_ADDRESS = P_DVR_IP_ADDRESS,
SIGNET_IP_ADDRESS = P_SIGNET_IP_ADDRESS,
NEAREST_POLICE_STN_NAME = P_NEAREST_POLICE_STN_NAME,
NEAREST_POLICE_STN_CONTNO = P_NEAREST_POLICE_STN_CONTNO,
NEAREST_HOSP_NAME = P_NEAREST_POLICE_STN_NAME,
NEAREST_HOSP_CONTNO = P_NEAREST_HOSP_CONTNO,
NEAREST_FIRE_STN_CONTNAME = P_NEAREST_FIRE_STN_CONTNAME,
NEAREST_FIRE_STN_CONTNO = P_NEAREST_FIRE_STN_CONTNO,
STORE_ADDRESS = P_STORE_ADDRESS,
STORE_SPACE_SQFT = P_STORE_SPACE_SQFT,
-- LAUNCH_DATE = P_LAUNCH_DATE,
LAUNCH_DATE = TO_DATE(P_LAUNCH_DATE, 'DD-MM-RR'),
CST_TIN_NO = P_CST_TIN_NO,
STORE_EMAILID = P_STORE_EMAILID,
NO_OF_POS = P_NO_OF_POS,
NO_OF_CAMERA = P_NO_OF_CAMERA,
DVR_MODEL_GESECURITY = P_DVR_MODEL_GESECURITY,
CAMERA_MODEL = P_CAMERA_MODEL,
ALIGNED_LPO_MAILDID = P_ALIGNED_LPO_MAILDID,
FACILTY_TEAMNAME = P_FACILTY_TEAMNAME,
FACILITY_TEAMNO = P_FACILITY_TEAMNO,
STATE_HEAD_OPS_NAME = P_STATE_HEAD_OPS_NAME,
STATE_HEAD_OPS_NO = P_STATE_HEAD_OPS_NO,
LPA = P_LPA,
SLP_STATE_HEAD = P_SLP_STATE_HEAD,
SLP_STATE_HEAD_NO = P_SLP_STATE_HEAD_NO,
CREATED_BY = P_CREATED_BY,
CREATED_DATE = SYSDATE,
LAST_UPDATED_BY = P_LAST_UPDATED_BY,
LAST_UPDATED_DATE = SYSDATE,
ISACTIVE = P_ISACTIVE,
LATITUDE = P_LATITUDE,
LONGITUDE = P_LONGITUDE
WHERE STORE_CODE = P_STORE_CODE;
--RETURNING RRSOC_ID INTO TBLDATA;
SELECT RRSOC_ID INTO TBLDATA FROM TBL_RRSOC_STORE_INFO WHERE STORE_CODE = P_STORE_CODE;
ELSE
INSERT INTO TBL_RRSOC_STORE_INFO
(
STORE_CODE,
STATE,
CITY,
SITE_STORE_FORMAT,
STORE_SITENAME,
STORE_SITENAME_LANDL_1,
STORE_SITENAME_LANDL_2,
STORE_ASST_MANAGER_NAME,
STORE_ASST_MANAGER_MOBNO,
STORE_MANAGER_NAME,
MANAGER_MOBNO,
EMP_NEAREST_STORE,
EMP_NEAREST_STORE_MOBNO,
SUPERVISOR_NAME,
SUPERVISOR_MOBNO,
SECURITY_SUP_NAME_STORE,
SECURITY_SUP_MOBNO_STORE,
NAME_ALIGNED_LPO,
LPO_MOBILENO,
ALPM_ALPO_NAME,
ALPM_ALPO_MOBNO,
AREA_MANAGER_NAME,
AREA_MANAGER_MOBNO,
ZONAL_HEAD_NAME,
ZONAL_HEAD_NO,
DVR_IP_ADDRESS,
SIGNET_IP_ADDRESS,
NEAREST_POLICE_STN_NAME,
NEAREST_POLICE_STN_CONTNO,
NEAREST_HOSP_NAME,
NEAREST_HOSP_CONTNO,
NEAREST_FIRE_STN_CONTNAME,
NEAREST_FIRE_STN_CONTNO,
STORE_ADDRESS,
STORE_SPACE_SQFT,
LAUNCH_DATE,
CST_TIN_NO,
STORE_EMAILID,
NO_OF_POS,
NO_OF_CAMERA,
DVR_MODEL_GESECURITY,
CAMERA_MODEL,
ALIGNED_LPO_MAILDID,
FACILTY_TEAMNAME,
FACILITY_TEAMNO,
STATE_HEAD_OPS_NAME,
STATE_HEAD_OPS_NO,
LPA,
SLP_STATE_HEAD,
SLP_STATE_HEAD_NO,
CREATED_BY,
CREATED_DATE,
LAST_UPDATED_BY,
LAST_UPDATED_DATE,
ISACTIVE,
LATITUDE,
LONGITUDE
)
VALUES
(
P_STORE_CODE,
P_STATE,
P_CITY,
P_SITE_STORE_FORMAT,
P_STORE_SITENAME,
P_STORE_SITENAME_LANDL_1,
P_STORE_SITENAME_LANDL_2,
P_STORE_ASST_MANAGER_NAME,
P_STORE_ASST_MANAGER_MOBNO,
P_STORE_MANAGER_NAME,
P_MANAGER_MOBNO,
P_EMP_NEAREST_STORE,
P_EMP_NEAREST_STORE_MOBNO,
P_SUPERVISOR_NAME,
P_SUPERVISOR_MOBNO,
P_SECURITY_SUP_NAME_STORE,
P_SECURITY_SUP_MOBNO_STORE,
P_NAME_ALIGNED_LPO,
P_LPO_MOBILENO,
P_ALPM_ALPO_NAME,
P_ALPM_ALPO_MOBNO,
P_AREA_MANAGER_NAME,
P_AREA_MANAGER_MOBNO,
P_ZONAL_HEAD_NAME,
P_ZONAL_HEAD_NO,
P_DVR_IP_ADDRESS,
P_SIGNET_IP_ADDRESS,
P_NEAREST_POLICE_STN_NAME,
P_NEAREST_POLICE_STN_CONTNO,
P_NEAREST_HOSP_NAME,
P_NEAREST_HOSP_CONTNO,
P_NEAREST_FIRE_STN_CONTNAME,
P_NEAREST_FIRE_STN_CONTNO,
P_STORE_ADDRESS,
P_STORE_SPACE_SQFT,
P_LAUNCH_DATE,
P_CST_TIN_NO,
P_STORE_EMAILID,
P_NO_OF_POS,
P_NO_OF_CAMERA,
P_DVR_MODEL_GESECURITY,
P_CAMERA_MODEL,
P_ALIGNED_LPO_MAILDID,
P_FACILTY_TEAMNAME,
P_FACILITY_TEAMNO,
P_STATE_HEAD_OPS_NAME,
P_STATE_HEAD_OPS_NO,
P_LPA,
P_SLP_STATE_HEAD,
P_SLP_STATE_HEAD_NO,
P_CREATED_BY,
SYSDATE,
P_LAST_UPDATED_BY,
SYSDATE,
P_ISACTIVE,
P_LATITUDE,
P_LONGITUDE
)
RETURNING RRSOC_ID INTO TBLDATA;
END IF;