SQL & PL/SQL

Dear all,

When executing a procedure am getting the below error :


SQL> @task.sql
SP2-0552: Bind variable "MI" not declared.

DECLARE
  my_task_name   VARCHAR2 (30);
  my_sqltext     CLOB;
 BEGIN
my_sqltext :='Select  a.billtext  CALL_TYPE, a.CALL_TYPE callDirection
, to_char(transdate, 'dd/mm/yy')    CALLDATE
, to_char(transdate, 'hh24:mi:ss')  CALLTIME
, NVL(b_subno,'********')           CALLEDNUMBER
, duration                          UNIT
, billamount                        AMOUNT
from
    selfcare.ESC_BP_CALL_DETAILS a, tabs.som_tabs_codes b
where
    contrno ='1000097864'
    and SUBNO ='50033300'
    and LAST_TRAFFIC_DATE = '31-AUG-09'
    and  b.code= a.call_type
    AND b.CODENAME='CALL_TYPE'
    and chargeType  in (SELECT CODE FROM tabs.SOM_TABS_CODES
                            WHERE
                                CODENAME='BILL_CHARGETYPE'
                                AND PARTCODE in('CALL_LOCAL'))
    and TARIFF_GROUP IN (SELECT CODE FROM tabs.SOM_TABS_CODES
                            WHERE
                                CODENAME='BILL_TARIFFGRP'
                                AND PARTCODE in('CALL_LOCAL'))
order by transdate asc)';
my_task_name := dbms_sqltune.create_tuning_task (sql_text=> my_sqltext,
      bind_list     => sql_binds (anydata.convertnumber (9)),
          user_name     => 'SELFCARE'
         scope         => 'COMPREHENSIVE',
         time_limit    => 60,
          task_name     => 'SELFCARE1',
         description   => 'Testing Slow Running Online Payslip Run'
      );
   END;
  /

Any idea what has to be changed ?


Kai