php - My Oracle Data is not inserting no matter what I do
one text
I am working on core php and I have to insert data into oracle system. The data will come from API from a flutter app. here is my query
$response = oci_parse($c,"INSERT INTO conf.confidential(WPP_MASTER_ID,CODE,TYPE_ID,WIP_ENTITY_ID,WIP_ENTITY_NAME,WPP_DATE_DATE,DURATION_HRS_F,DURATION_HRS_T,WPP_ISSUED_TO,WPP_ISSUED_TO_NAME,WPP_ISSUED_TO_DEPT_NAME,WORK_ORDER_DESCRIPTION,WORK_ORDER_CHANGE_DESC,ASSET_DESCRIPTION,ASSET_DEPARTMENT,ASSET_ACTIVITY,STATUS,PARA1,ISOLATED_BY_ID,ISOLATED_BY,PARA2,PARA3,PARA4,PARA5,PARA6,PARA7,PARA8,PARA9,PARA10,INVIGILATOR_BY_ID,INVIGILATOR_BY,INVIGILATOR_REMARKS,ANY_OTHER_PRECAUTION,PRORECTIVE_EQPT_1,PRORECTIVE_EQPT_2,PRORECTIVE_EQPT_3,PRORECTIVE_EQPT_4,PRORECTIVE_EQPT_5,PRORECTIVE_EQPT_6,PRORECTIVE_EQPT_7,PRORECTIVE_EQPT_8,PRORECTIVE_EQPT_9,PRORECTIVE_EQPT_10,PRORECTIVE_EQPT_NONE,EXTENSION_FLAG,WPP_RECEIPT_TO,WPP_RECEIPT_TO_NAME,WPP_RECEIPT_TO_DEP_NAME,CREATED,CREATED_BY,UPDATED,UPDATED_BY,SAFTEY_ANALYSIS,WF_LEVEL,OWNING_DEPARTMENT,OWNING_DEPARTMENT_CODE,DURATION_HRS,ASSET_NUMBER,ASSET_AREA,RECEIVED_BY,EXTEND_BY,EXTENDED_RECEIVED_BY,EXTEND_DATE,EXTEND_HOURS,RECEIVED_DATE,COMPLETED_BY,COMPLETED_DATE,COMPLETED_RECEIVED_BY,COMPLETION_REMARKS,EXTENSION_REMARKS,LEL_LEVEL,CODE_NEW,CODE_OLD)
VALUES ('3287','1PP03PMC22031082','Cold','null','11588174','1-MAY-22','1-MAY-22','1-MAY-22','null','Test Test Test','null','This Work Permit is only used for test purpose','null','GLYCOL CIRCULATION PUMP','null','null','Submitted','N','null','null','N','N','N','N','N','N','N','N','null','null','Muhammad Nauman Ali','null','Be careful, avoid any damage','Y','Y','N','N','N','Y','N','N','null','null','N','null','null','null','null','28-MAR-22','Majid Iftikhar ','28-MAR-22','majid.iftikhar@ifl.net','null','2','658','PP1 POLY3M','4','110305-1868-P05-001','1103-01-POLYMER +0.0M','null','null','null','null','null','null','null','null','null','null','null','null','1PP03PMC22031082','null')");
This is the error I am receiving at the moment,
<br />
<b>Warning</b>: oci_execute(): ORA-01722: invalid number in <b>C:\xampp\htdocs\workpermit\workpermit_createWorkPermit.php</b> on line <b>19</b><br />
{"status":"false","data":"No data Found"}
I don't know what am I doing wrong, even If I remove the first two values, and columns I still get the error. Has anyone ever faced such issue?
Source