Trapping a value returned by an SQL stored 'function'? 1

[Phathi]

Hi,

I have a problem trying to trap a value which is returned by a stored SQL function (PL/SQL).

what I have is
dim SQL as string
SQL = "Declare Param VARCHAR(500);" & _
"BEGIN functionname(inVar,inVar2); End;"
myConn.execute SQL

now this works fine for a procedure, but I need to trap the value of Param so as to display.

A colleague suggested ADODB.Parameters but I can't seem to et it right.

Help...

 

[dannyh]

use an ADO command object to fire your stored proc and add a line something like :

oCommand.Parameters.Append .CreateParameter("lID",Integer, adParamInputOutput, , lvID)

Dan.