--The Following Objects are at Remot Database

-- Object Creation

CREATE TYPE MTR_BAL_INFO_OBJ  AS OBJECT
(BALANCE_ID         NUMBER,
 BALANCE_CURRENT    NUMBER(18,2),
 BALANCE_CHANGE     NUMBER(18,2),
 BALANCE_EXPIRY     DATE);

-- VArray Creation

CREATE TYPE MTR_BAL_INFO_ARRAY
AS VARRAY(20) OF MTR_BAL_INFO_OBJ;

-- Table Creation

CREATE TABLE MTR_HISTORY
(
  SUBSCRIBER_ID      VARCHAR2(30)               NOT NULL,
  LOGIN_NAME         VARCHAR2(30)               NOT NULL,
  MOD_DATE           DATE                       NOT NULL,
  MTR_COMMENT        VARCHAR2(200),
  DISCOUNT_PLAN_ID   NUMBER,
  BONUS_PLAN_ID      NUMBER,
  BONUS_AWARDED      NUMBER,
  DISCOUNT_AWARDED   NUMBER,
  UNIT_TYPE_ID       NUMBER,
  IDENTITY_ID        NUMBER,
  GROUP_ID           VARCHAR2(25),
  CHARGE_CODE        VARCHAR2(10),
  ACCOUNT_TYPE       NUMBER,
  FUND_USAGE_TYPE    NUMBER,
  ISO_CODE           VARCHAR2(4),
  PREV_ISO_CODE      VARCHAR2(4),
  CONVERSION_RATE    NUMBER(38,6),
  PREV_COS_ID        NUMBER,
  CURRENT_COS_ID     NUMBER,
  SP_ID              NUMBER(38),
  BALANCE_INFO       MTR_BAL_INFO_ARRAY,
  ACCUMULATORS_INFO  MTR_ACC_INFO_ARRAY,
  ALCS_INFO          VARCHAR2(500),
  EXT_FIELD          VARCHAR2(4000),
  UPLOAD_DATE        DATE                       DEFAULT TO_DATE(SYSDATE)      NOT NULL
);


-- I have created DBLink in my db and dblink is working

-- My query is as follows but it's not working.

select
TO_CHAR(MOD_DATE,'DD-MON-YYYY') MOD_DATE,
TO_CHAR(MOD_DATE,'HH24:MI:SS') MOD_TIME,
LOGIN_NAME,
UNIT_TYPE_ID,
x.BALANCE_ID,
x.BALANCE_CHANGE,
x.BALANCE_EXPIRY,
x.BALANCE_CURRENT from mtr_history@dblink a, table(a.balance_info ) x;