How to get the sql query result?

[TanTan]

Hi,

Currently I am using LV2012 to connect a Oracle database server. After the installations/settings for Oracle Express and Oracle ODBC driver done.

I am sucessfully to use the SQL command to query the data through my window command prompt. 

Now the problem is, how I do the same task in Labview by using the database connectivity toolkits?

I have build a VI for query as attached, but i have no idea what pallete to use to get the query result.

Please help me ~~

[Ola_A · Accepted solution]

Here is a piece of code I use to test SQL commands, you can use the part that retrieves sql results.

It is also possible to get the column headers back, but that is for next lesson!

😉

[JPSaez]

This is how I execute a store procedure. I hope it helps.