Function Return Value to VB6
Hi all, I have a stored function that I call from a VB6 app. The function returns a "1" if successful and a "0" on failure. Obviously, I can see the result during development in a DBMS Output window but how do I pass this value to my VB app?
Thanks in advance,
Create a command object in VB,
Create a parameter and call the function.
better u put the function in a package and call it as
pkg.functionname from vb.
check the above 2 links,
Dim Rs as adodb.recordset.
rs.open "select FunctionName(Parameters) from dual",conn...
rs(0).value is what u want..
Click Here to Expand Forum to Full Width