Re: How to execute store procedure from VB?

From: MarkyG <markg_at_mymail.tm>
Date: 11 Dec 2001 02:22:21 -0800
Message-ID: <ab87195e.0112110222.7a5fdf5f@posting.google.com>

To get you started....

Oradatabase is defined as Oradatabase (in General -> Declarations) Procedure pk_rm_request.check_For_Previous_Load takes one input parameter and one output parameter.

Using OO4O

   With OraDatabase

      ' Input Parameters
      
      .Parameters.Add "BatchNo", "999", ORAPARM_INPUT
      .Parameters("BatchNo").serverType = ORATYPE_VARCHAR2
                     
      ' Output Parameters
           
      .Parameters.Add "RetVal", 0, ORAPARM_OUTPUT
      .Parameters("RetVal").serverType = ORATYPE_VARCHAR2

   End With    

   Set PlSqlStmnt = OraDatabase.CreateSql("Begin pk_rm_request.check_For_Previous_Load(:BatchNo, :RetVal); END ; ", 0&)

HTH M

"Hon" <yicng_at_mediaone.net> wrote in message news:<1NfR7.16173$g96.203781_at_typhoon.mw.mediaone.net>...
> Hi,
>
> I would like to know what are the steps and code I need to do when I want to
> call a store procedure with parameters from oracle?
>
> Thanks.
>
> Hon
Received on Tue Dec 11 2001 - 04:22:21 CST