PROCEDURE return_num(xNum OUT NUMBER) AS
  BEGIN
    xNum:= 50;
    dbms_output.put_line('hello world ' || xNum);
  END;

Oraclecon.Open();
                    OleDbCommand myCMD = new            OleDbCommand("TEST.return_num", Oraclecon);
                    myCMD.CommandType = CommandType.StoredProcedure;
                    myCMD.Parameters.Add("xNum", OleDbType.Numeric);

                    OleDbDataReader myReader;
                    myReader = myCMD.ExecuteReader();

TYPE r_interface_data IS RECORD
    (
     object_id             VARCHAR2(16),
     obj_type              VARCHAR2(32)
    );

    TYPE t_interfase_data IS TABLE OF r_interface_data;