Problem with parameterized procedure in Labview and Oracle9i

[dudognof]

Hello,

I have a problem using parameterized procedure in Labview and client Oracle 9i.
I have a labview 6.1 application using database connectivity toolset 1.0.1 witch run parameterized procedure on a Oracle 9i database.
Everything is OK with Oracle 8.1.7 Client but I have the following error with Oracle 9.2.0.1 Client :
-2147217887 Microsoft OLE DB Provider for ODBC Driver Multiple Step OLE DB Operation.

has anybody encoutered this problem ?
Thanks a lot for response.
Regards

dudognof

[Marc L.]

Hello,

We are working on it.
In the Connection Get Properties VI, specify an other timeout depending on your application. Give an other name to the VI and use it.

Marc Larue
NIF

[dudognof]

Hello,

I tried things you told me but it does not work. Same error at same vi.

Thank for your help,

Fabrice Dudognon

[Marc L.]

Hello,

Make sure you have the latest versions of MDAC and Oracle ODBC drivers.
See the following links :

http://www.oracle.com/technology/software/tech/windows/odbc/index.html

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

regards,

Marc Larue
NIF

[ctc]

Hi all, I have almost the same problem...

I use the following boxes to execute a stored procedure on oracle:

- Open connection
- Create parameterized query
- Set parameter value
- Execute query
- Free object
- Close connection

I have problems with the second vi.

My question is: what should I connect to the inputs of the box to be able to run a stored procedure (which has input parameters) on an oracle server?

I have tested a stored procedure which had no parameters (arguments) at all, and it worked. Thus, I'm sure that it is not a server-side (DB server related) problem, but the problem and the solution is hided in the LabVIEW.

Our system is: Oracle 9i R2, LabVIEW 7.1, Oracle OLEDB Provider (the latest).

Attached you can find an example created by me, but it doesn't work:(

Many many thanks for your help, ctc

[dudognof]

Thanks for your interest,

I have installed the latest versions I could :
* ORACLE ODBC Driver 92054
* MDAC 2.8
The problem is still here.

I could not install latest versions for ORACLE ODBC Driver because of my version of ORACLE Universal Installer (2.2).

Regards,

Fabrice Dudognon

[Crystal]

Stored procedures can be a little tricky. I've attached a screen capture of a VI I used to call a simple stored procedure for Oracle. It has both input and output parameters. Notice a couple of things:
- The format of the stored procedure call has question marks for each of the parameters where the order of the question marks matches the order/type of the items in the parameters array. For example, the full stored procedure call would look like: {class = CALL INKA4.INKA4_SYS.GET_ERROR(code,text)} where class and code are long ints and text is a string (or varchar2 in Oracle).
- The input parameter values need to be defined with the Set Parameter Value VI before you call the stored procedure with the Execute Query.
- The output parameters are then read using the Get Parameter Value VIs.

I hope this information helps. Keep in mind that the syntax for calling stored procedures changes quite a bit if you are using other database management systems.

One last note is that I've had much better success with communications between Oracle and LabVIEW when I'm using Oracle's drivers (ODBC or OLE DB) rather than Microsoft's.

[Crystal]

here's the attachment:

[sumitrishi]

dudognof,

Did you find a solution to this then ?
If you did please assist me I am having similar trouble were I have to shift from oracle 8 to oracle 9.2

Thanks
Sumit

[Simbani]

I am using LabVIEW v.8. and the Database Connectivity Toolkit latest version. I have connected to an Oracle DB v.10 with the Oracle latest drivers. I am able to read from the Oracle without any problem. However, when I try to insert or update data to the Oracle Data Base I get the error -2147217887 Provider does not support the property.in Conn Get Properties.vi In some occassions, the register does exist, then I use the Update instead of the Insert but I get the same error Thanks in advanced for any help Thanks Simbani