Binding an array to an input variable in OCI

Bruce Collie

Hi,

I want to bind an array to the following sql statement using oci

SELECT UUID FROM TEST WHERE TYPE=:VAL

UUID is INTEGER
TYPE is CHAR(1)

If i use obndrv it only ever seems to use the first value in the array.
If i use obindps (which i've not used before) i cannot seem to get the
parameters correct, i get various different errors.

Does anybody know what is going wrong?
Any chance of a code sample for this?

Thanks
Bruce Collie

Sep 3 '05 #1

Subscribe Post Reply

5569

HansF

CHapter 5 of Oracle's document "Oracle Call Interface Programmer's Guide"
is all about binding. Includes a section on binding with arrays and has
examples.

http://download-west.oracle.com/docs...bnd.htm#420516

You might want to switch to the officially chartered group
'comp.databases.oracle.server'. (As compared to this one that was
created as a result of a typo - 'database' instead of 'databases'.)
Non-chartered groups are not carried by many news providers so you are
missing a lot of possible support people.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Sep 3 '05 #2

Similar topics

MS Graph - Late Binding Question

by: JD Kronicz | last post by:

Hi .. I have an issue I have been beating my head against the wall on for some time. I am trying to use late binding for MS graph so that my end users don't have to worry about having the right...

Microsoft Access / VBA

late binding an ActiveX Executable with multiple return arrays

by: JL_327 | last post by:

No one on any of the other boards seem to know In VB.Net this late binding works fine Dim Version As Integer Dim Revision As Integer Dim Wnum As Integer Dim o As System.Array =...

C# / C Sharp

VB.net to C# conversion for late binding - please help

by: JL_327 | last post by:

No one on any of the other boards seem to know In VB.Net this late binding works fine Dim Version As Integer Dim Revision As Integer Dim Wnum As Integer Dim o As System.Array =...

C# / C Sharp

Early binding arrays, best technique

by: mark | last post by:

I understand that writing programs with option strict on is the best way to obtain stable applications. I have also found the applications to run much faster. Option strict on disallows late...

Visual Basic .NET

Late Binding

by: lgbjr | last post by:

hi All, I've decided to use Options Strict ON in one of my apps and now I'm trying to fix a late binding issue. I have 5 integer arrays: dim IA1(500), IA2(500), IA3(500), IA4(500), IA5(500) as...

Visual Basic .NET

Variable passed in GET or POST array

by: Chuck Anderson | last post by:

I have finally started coding with register_globals off (crowd roars - yeay!). This has created a situation that I am not sure how I should handle. I have scripts (pages) that can receive an...

PHP

Late Binding Issue

by: Miro | last post by:

VB 2003 and Im still new to vb, so i hope i can explain this as best I can. I have a variable defined as such: ( simple example ) Dim AVariableOfSorts(,) As Object = _ { _ {"Last", "String",...

Visual Basic .NET

Variable passed to each() is not an array or object

by: assgar | last post by:

I am having problems getting the user selected form info to inserted into the mysql database. I am also rec eving an error: Warning: Variable passed to each() is not an array or object in ...

PHP

Binding an array to an input variable in OCI

by: Bruce Collie | last post by:

Hi, I want to bind an array to the following sql statement using oci SELECT UUID FROM TEST WHERE TYPE=:VAL UUID is INTEGER TYPE is CHAR(1) If i use obndrv it only ever seems to use the...

Oracle Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing