Return value in Oracle

See more:

SQL

Oracle

I have this set of code that is able to be compiled perfectly. However the only trouble I seem to be having is returning the value of the c_list.

c_list is able to show me the values in DBMS Output but I am not able to display it in DataGrid. I want to use this code to display the return values into a gridview in ASP.NET.

This is my code:

 CREATE OR REPLACE PACKAGE BODY GSI_GIC.PK_GSIMSGDATA AS
   PROCEDURE GSIMSG_Data(index_n IN NUMBER) IS
   CURSOR c_Data is
      SELECT  msg_ID FROM GSI_SWIFT_MSG_NEW;
   TYPE c_list is TABLE OF GSI_SWIFT_MSG_NEW.msg_ID%type;
   data_list c_list := c_list();
   counter integer :=0;
   BEGIN
    return c_list
     END GSIMSG_Data;
END PK_GSIMSGDATA;