Geek Answers Handbook

OR-01036; name / number of prohibited variable

I have the following insert request

include("ORCLconfig.php"); $addAclaim = oci_parse($conn, "INSERT INTO claims_accidents (ID, CLAIM_NUMBER, DATE_OF, TIME, LOCATION, PURPOSE, WEATHER, ROAD, STREET_LIGHTS, SPEED_LIMIT, SPEED_PRIOR, SPEED_AT_MOMENT, AIRBAGS, AMBULANCE, SIGNALS, OCCUPANTS, DESCRIPTION, ROAD_LOCATION, PH_DRIVING, NAME_OF_DRIVER, DRIVER_DOB, DRIVER_OCCUPATION, MEDICAL_CONDITIONS, DRIVER_CONVICTIONS, AUTHORISED, DRIVER_ADDRESS1, DRIVER_ADDRESS2, DRIVER_ADDRESS3, DRIVER_ADDRESS4, DRIVER_POSTCODE, DRIVER_TELEPHONE, MATCH, V5_NUMBER, KEY_SETS, OS_FINANCE, VEHICLE_VALUE, VEHICLE_REG, VEHICLE_MAKE, VEHICLE_MODEL, NAMED_DRIVER, FATALITIES, DRIVEABLE) VALUES (null, :claimnum, :date_of_accident, :time_of_acc, :location_of_acc, :purpose, :weather, :road, :lights, :speedLimit, :speedPrior, :speedImpact, :airbags, :ambulance, :signals, :occupants , :accdesc, :street_of_acc :ph_driving, :driverName, :DRIVER_DOB, :driverOccupation, :driverMedical, :driverConvictions, :auth, :driverAddress1, :driverAddress2, :driverAddress3, :driverAddress4, :driverPostcode, :driverTelephone, :match, :v5number, :keySets, :osf, :vehicle_value, :vehicle_reg, :vehicle_make, :vehicle_model, :named, :fatal, :driveable)"); oci_bind_by_name($addAclaim, ":claimnum", $claimnum); oci_bind_by_name($addAclaim, ":date_of_accident", $date_of_accident); oci_bind_by_name($addAclaim, ":time_of_acc", $time_of_acc); oci_bind_by_name($addAclaim, ":location_of_acc", $location_of_acc); oci_bind_by_name($addAclaim, ":purpose", $purpose); oci_bind_by_name($addAclaim, ":weather", $weather); oci_bind_by_name($addAclaim, ":road", $road); oci_bind_by_name($addAclaim, ":lights", $lights); oci_bind_by_name($addAclaim, ":speedLimit", $speedLimit); oci_bind_by_name($addAclaim, ":speedPrior", $speedPrior); oci_bind_by_name($addAclaim, ":speedImpact", $speedImpact); oci_bind_by_name($addAclaim, ":airbags", $airbags); oci_bind_by_name($addAclaim, ":ambulance", $ambulance); oci_bind_by_name($addAclaim, ":signals", $signals); oci_bind_by_name($addAclaim, ":occupants", $occupants); oci_bind_by_name($addAclaim, ":accdesc", $accdesc); oci_bind_by_name($addAclaim, ":street_of_acc", $street_of_acc); oci_bind_by_name($addAclaim, ":ph_driving", $ph_driving); oci_bind_by_name($addAclaim, ":driverName", $driverName); oci_bind_by_name($addAclaim, ":DRIVER_DOB", $DRIVER_DOB); oci_bind_by_name($addAclaim, ":driverOccupation", $driverOccupation); oci_bind_by_name($addAclaim, ":driverMedical", $driverMedical); oci_bind_by_name($addAclaim, ":driverConvictions", $driverConvictions); oci_bind_by_name($addAclaim, ":auth", $auth); oci_bind_by_name($addAclaim, ":driverAddress1", $driverAddress1); oci_bind_by_name($addAclaim, ":driverAddress2", $driverAddress2); oci_bind_by_name($addAclaim, ":driverAddress4", $driverAddress4); oci_bind_by_name($addAclaim, ":driverPostcode", $driverPostcode); oci_bind_by_name($addAclaim, ":driverTelephone", $driverTelephone); oci_bind_by_name($addAclaim, ":match", $match); oci_bind_by_name($addAclaim, ":v5number", $v5number); oci_bind_by_name($addAclaim, ":keySets", $keySets); oci_bind_by_name($addAclaim, ":osf", $osf); oci_bind_by_name($addAclaim, ":vehicle_value", $vehicle_value); oci_bind_by_name($addAclaim, ":vehicle_reg", $vehicle_reg); oci_bind_by_name($addAclaim, ":vehicle_make", $vehicle_make); oci_bind_by_name($addAclaim, ":vehicle_model", $vehicle_model); oci_bind_by_name($addAclaim, ":named", $named); oci_bind_by_name($addAclaim, ":fatal", $fatal); oci_bind_by_name($addAclaim, ":driveable", $driveable); oci_execute($addAclaim, OCI_COMMIT_ON_SUCCESS);

Every time I try to run this request, I get this error

 oci_bind_by_name(): ORA-01036: illegal variable name/number

I did a little research and apparently this means that one of the variables is not contained in the SQL statement. This does not apply to me, I check the statement, the DB table (which is the oracle) and all the associated variables, and they all match.

The line number in the error indicates that this is a $ driveable variable. I checked and it goes to the page in order.

Not sure where else to look so that any help would be great.

+6
source share
3 answers

You seem to have missed the comma here,

 :street_of_acc :ph_driving,

Must be

 :street_of_acc, :ph_driving,
+18
source

In addition to @bonCodigos answer you are not :driverAddress3 attached :driverAddress3

+2
source

If you also have a visual studio and you use the detail view. I suggest reconfiguring your data source. I was getting error ORA-01036, and all I had to do was just reconfigure my SQL source and it generated it correctly for me. For me, it was that I did not properly process the original values ​​when I tried to update my data source.

I was at Oracle too.

0
source

More articles:


All Articles