What Does Error -2147467259 Mean When Connecting to an Oracle Database?

Updated Jan 19, 2023

Reported In

Software

  • LabVIEW Database Connectivity Toolkit
  • LabVIEW

Issue Details

I have an application that requires me to connect to an Oracle Database. When I try and update a table in Oracle, I get Error -2147467259 from the DB Tools Insert Data VI. I have the latest version of the Oracle ODBC driver. What does this error mean, and how can I send data to Oracle from LabVIEW?

Solution

The DB Tools Insert Data VI expects a cluster of data to be connected to the data input. You must have each variable in the cluster defined to be the appropriate data type. If you have all entries in the cluster defined as strings and the Oracle table is expecting numerics, you will receive the error message:

Error: -2147467259 
expecting a number but receiving a binary

Also, be sure to use the DB Tools Format Datetime String VI from the Utilities sub-palette to correctly format any date or time entries that you need to send to the Oracle database.

Related Links

LabVIEW Database Connectivity Toolkit User Manual

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement may be required, and support options vary by country.