Passing arrays to oracle stored procs through vb(ado)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Passing arrays to oracle stored procs through vb(ado)

  1. #1
    kanchana Guest

    Passing arrays to oracle stored procs through vb(ado)


    I need help on passing Arrays as parameters to Oracle Stored Procedures
    using ADO in Visual Basic 6.

    The Stored Procedure in Oracle has the following parameters:

    IN:
    abc1 : char
    abc2 : char
    abc3 : char


    OUT
    abd1 :char
    abd2 :varchar2
    abd3 :char10_array
    abd4 :vc2_array

    Iam using the parameters collection of the command object using the create

    and append methods.

    But iam facing problems regarding this.

    I even tried using the refresh method but no success.

    If sample cud be also provided then double thanks.
    regards
    kanchana

    c_kanchana@yahoo.com


  2. #2
    marc Guest

    Re: Passing arrays to oracle stored procs through vb(ado)


    see the site below

    http://news.devx.com/cgi-bin/dnewswe...em=10215&utag=

    marc

    "kanchana" <c_kanchana@yahoo.com> wrote:
    >
    >I need help on passing Arrays as parameters to Oracle Stored Procedures


    >using ADO in Visual Basic 6.
    >
    >The Stored Procedure in Oracle has the following parameters:
    >
    >IN:
    >abc1 : char
    >abc2 : char
    >abc3 : char
    >
    >
    >OUT
    >abd1 :char
    >abd2 :varchar2
    >abd3 :char10_array
    >abd4 :vc2_array
    >
    >Iam using the parameters collection of the command object using the create
    >
    >and append methods.
    >
    >But iam facing problems regarding this.
    >
    >I even tried using the refresh method but no success.
    >
    >If sample cud be also provided then double thanks.
    >regards
    >kanchana
    >
    >c_kanchana@yahoo.com
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center