Arrays in Stored procedure

Results 1 to 3 of 3

Thread: Arrays in Stored procedure

  1. #1
    Kamau Guest

    Default Arrays in Stored procedure

    Is it possible to use arrays in a stored procedure? If so, how? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Arrays in Stored procedure

    do you mean as a parameter to be passed in, or a as a structure within the SP?

  3. #3
    Nata Guest

    Default RE: Arrays in Stored procedure

    Can i pass a parameter in a SP like a structure user-defined from a VB component?<BR>For example a define the parameter IN in the SP like<BR>TYPE tstr20 is TABLE of VARCHAR2(20) index by BINARY_INTEGER; <BR>and i want to pass through the VB component that call the SP a structure user defined like :<BR>Public Type param_list<BR> p1 As String<BR> p2 As String<BR> p3 As String<BR>End Type<BR>or an array like:<BR>dim param_list as variant(2)<BR><BR>But when i open the recordset failed.<BR>I thought that my problem is when i create the parameter to the Command element, because i don&#039;t know which is the correct type (AdVariant, adIunknow, etc)<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts