Re: VB calling stored procedure question

On Fri, 13 Feb 1998 01:15:09 -0800, "Ted Dressel" <ted_at_end2end.com> wrote: Hi,

try something like

        dbMine.execute(szLclSQL,64) '64 means pass through         

where szSql is something like:

        "Begin <package name>.<procedure name>(par1,par2, ..); end;

Remember to enclose string expression in single quotes.

>I believe the following is a simple question for which we are looking for
>direction:
>
>Given Oracle 7.3 running on NT using TCP/IP for connectivity, can a VB app
>running RDO2.0 call a stored procedure in a package body? Can a VB app call
>a stored procedure outside a package body?
>
>Our problem is that a package body created by a consultant who is no longer
>on the project exists that has a stored procedure that we want to access
>from VB by calling it via RDO (some how). But currently, the code does not
>return any type of return status. How does one call a stored procedure in
>Oracle 7.3?
>
>Any simple direction would help!
>
>-Ted (ted_at_end2end.com)
>
>"VB calling stored procedure question"
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de