jose luis wrote:
> Hi everybody..
>
> I'm trying to execute a stored procedure in orecle, from my visual
> basic script.
> How can i do this? and how can i display the results ?
>
> This is my function
> It is in the package: XXEX_WS_PKG
>
> FUNCTION is_New_LstEq ( p_msg OUT VARCHAR2,
> p_propertynum IN VARCHAR2 )
> RETURN NUMBER;
>
> witch are the instructions in Vbs so i can call this function and
> display the results?
>
> Thanks in advance
To return results from Oracle to VB your output should be a REF CURSOR.
How you would go about executing it would depend on whether it is a
stand-alone procedure or in a package and you have provided a dearth
of information from which to formulate an answer: Not even a version
number. I'd suggest http://otn.oracle.com and google if you don't get
what you need here.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Feb 01 2006 - 13:03:02 CST
