php - My Oracle Data is not inserting no matter what I do

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','[email protected]','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')");  
Copy code

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"}
Copy code

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?

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.