Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    India
    Posts
    6

    Unanswered: Passing an Array to stored procedure

    Hi Gurus

    I want to write a stored procedure which can accept array as an parameter.

    or

    Any other alternative way for sending multiple records to the procedure for insertion


    Thanks in Advance

    Regards

  2. #2
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89
    Its possible.
    Declare a package .
    It shud have a pl/sql table.say


    TYPE tblVarchar IS TABLE OF VARCHAR2(3000) INDEX BY BINARY_INTEGER;

    In your procedure declare the datatype as tblVarchar.
    This can accept arrays.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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