Hi i have a stored procedure in oracle i want to pass an array to store procedure and process it , can any one help me how to do it.

Hi, Munawwar

Simple example how to use array:

CREATE PACKAGE MyPkg IS

  TYPE MyType ( field1 number );
  TYPE MyArray IS TABLE OF MyType INDEX BY BINARY_INTEGER;

  PROCEDURE MyProc ( inArray in out MyArray );

END;

CREATE PACKAGE BODY MyPkg IS

  PROCEDURE MyProc ( inArray in out MyArray ) IS
  BEGIN
     ...
     your code
     ...
  END;

END;

Execute procedure MyProc:

DECLARE
  tmpArray MyPkg.MyType;
BEGIN
  FOR i IN 1..3 LOOP
    tmpArray( i ) := 1;
  END LOOP;
  MyPkg.MyProc( tmpArray );
END;

Also you can create type "MyType" as DB type...

Good luck!