Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: VB calling stored procedure question

Re: VB calling stored procedure question

From: Brad Murray <BradMurray_at_SeeSignatureIfThere.com>
Date: 1998/02/13
Message-ID: <MPG.f4e2ad45becadb989978@news>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US