Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: VB calling stored procedure question
In article <6c130o$c2k_at_bolivia.earthlink.net>, ted_at_end2end.com said...
> 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?
You just call it.
With your database connection, call the execute method with the following:
{ CALL ProcName(ArgList) } Received on Fri Feb 13 1998 - 00:00:00 CST
![]() |
![]() |