Kevin Méndez
Kevin Méndez

Reputation: 1

Passing array for Oracle stored procedure with LabVIEW

I am trying to develop a LabVIEW vi that is able to transfer some parameters to an Oracle stored procedure using the LabVIEW Database Connectivity Toolkit.

I have been researching and following examples from Toolkit Documentation (chapter7) https://download.ni.com/support/manuals/371525a.pdf , yet I have not been able to pass an array as parameter.

At the very end of chapter, it states "The stored procedure examples shown in this section are specifically written for SQL Server. Oracle uses PL/SQL to create stored procedures. Although the syntax for PL/SQL is different, you still can create and run stored procedures for Oracle using the Database Connectivity Toolkit." but I wonder if someone has been able to succeed passing an array for an Oracle stored procedure or if a different approach should be used.

This because manual states we are able to do it but I encounter an error when using arrays (passing parameter one by one is functionable yet not a solution for my particular case), and Toolkit also mentions we should use binary instead of arrays, which confuse me as manual examples do not use binary data types for array conversion. data-types conversion

Upvotes: 0

Views: 108

Answers (0)

Related Questions