using parameterized stored function

[Lorand]

Hi,

I've been searching the forum and the knowledgebase for information about using a parameterized stored database function. I was not able to find out how to retrieve the returnvalue of a function like this, when setting the parameters via the "Create Parameterized Query.vi" (DB-Connectivity-Toolset):

  FUNCTION get_ftprocess_id (

    userID IN NUMBER,

    processID IN VARCHAR2)
    RETURN NUMBER;

Lorand

[Philipp R.]

Dear Lorand

Have a look at the "Parameterized.vi" in "C:\Programme\National
Instruments\LabVIEW 8.2\examples\database\DatabaseEx.llb". Should be a
good starting point for your task.

Best regards

Philipp R.

[Lorand]

Thank's for your reply Philipp, but there is no example for executing parameterized stored database-functions.

Lorand

[Philipp R.]

Dear Lorand

The DB Tools Create Parameterized Query.vi works identically
for stored procedures, you just have to set stored procedure
to TRUE and SQL query to the name of the
procedure.

For an example about the retrieval of output parameters see the
KnowledgeBase article at
http://digital.ni.com/public.nsf/allkb/07FD130746083E0686257300006326C4.

Best regards

Philipp R.

[Lorand]

Dear Philipp,

the thing is, that the call of a stored function is different from the call of a procedure because the function returns a "RETURN VALUE".
I found help at the following knowledgebase-document:
http://digital.ni.com/public.nsf/allkb/9EDDED1E89054FEA86256DB400551780

the synthax: {? = call storedfunction(?, ?)}

Thanks for your help

Lorand

[Lorand]

Another question:

How do I rate an answer?

Lorand

[Philipp R.]

Dear Lorand

I'm glad you were able to find a solution!

At least in my browser (Safari) rating doesn't seem to work at the moment:
I click one of the 5 radiobuttons and they disappear after that but nothing
meaningful happens.

Best regards

Philipp R.

[Lorand]

...seems to be a new thread.

I don't even see any radionbuttons in "Mozilla-Firefox" as well as in InternetExplorer.

Lorand