0 Replies Latest reply: Jan 30, 2013 5:14 PM by user13653962 RSS

    Error ORA-01461: can bind a LONG value only for insert into a LONG column

    user13653962
      Within an existing application , i need to create a new report , i created a new page in it and then tried to create classic report , during wizard when i enter the same query which i have used for previous page , it gives me following error during the creation of report.

      The following bind variable i have already used for previous page. I want to reuse the same bind variables. There is no any long dataype within column predicates.
      Error ORA-01461: can bind a LONG value only for insert into a LONG column 
         
         
      OK 
       
      Following is the query
      SELECT 
         "VWSR_ALL_MERGED_DATA_MV"."SR_AREA" "SR_AREA", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_STATUS" "SR_STATUS", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_SUB_STATUS" "SR_SUB_STATUS", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_DATE_CREATED" "SR_DATE_CREATED", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_OPEN_DATE" "SR_OPEN_DATE", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_CLOSED_DATE" "SR_CLOSED_DATE", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_PRODUCT1" "SR_PRODUCT1", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_PRODUCT2" "SR_PRODUCT2", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_TIO_PRIORITY" "SR_TIO_PRIORITY", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_REF_NUMBER" "SR_REF_NUMBER", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_DATE_RECD" "SR_DATE_RECD", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_CIDN" "SR_CIDN", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_BUS_UNIT" "SR_BUS_UNIT", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_NUMBER" "SR_NUMBER", 
         "VWSR_ALL_MERGED_DATA_MV"."SOURCE_SYSTEM" "SOURCE_SYSTEM", 
         "VWSR_ALL_MERGED_DATA_MV"."BATCH_ID" "BATCH_ID"
       FROM VWSR_ALL_MERGED_DATA_MV
      WHERE trunc(VWSR_ALL_MERGED_DATA_MV.SR_DATE_RECD)=trunc(sysdate-1) 
        AND VWSR_ALL_MERGED_DATA_MV.SR_TIO_PRIORITY  IN 
                                                    (
                                                      :P2_SR_TIO_PRIORITY
                                                     ,'CEO'
                                                     ,'TER'
                                                     ,'Priority Assistance'
                                                     ,'Enquiry'
                                                     )
        AND   ( 
              (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                                         (
                                           'Business Support and Improvement'
                                         , 'Finance and Administration'
                                         , 'Cust Sat Simplification and Productivity'
                                         , 'Project New and Customer Experience'
                                         , 'Corp Strategy and Customer Experience'
                                         , 'Other'
                              )
                  AND :P2_SR_BUSINESS_UNIT= htf.escape_sc('BS&I'))
         OR   (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                                         (
                                           'Consumer'
                                         , 'Consumer Telstra Country Wide'
                                         , 'Customer Service and Sales'
                                         , 'Offshore Sales and Service'
                                         , 'TC and TCW Operations'
                                         , 'Telstra Country Wide'
                                         , 'Other'
                                         )
                  AND :P2_SR_BUSINESS_UNIT= htf.escape_sc('TC&C'))
         OR   (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                             (
                               'Telstra Customer Sales and Service'                   
                              ,'Telstra Program Office'
                              ,'Human Resources'
                              ,'IT'
                              ,'Unallocated'
                              ,'Other'
                             )
                  AND :P2_SR_BUSINESS_UNIT= 'OTHER')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                        (
                          'Telstra Operations'
                         ,'Telstra Networks and Services'
                         ,'Other'
                         )
                  AND :P2_SR_BUSINESS_UNIT= 'TO')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Telstra Business'
                        )
                  AND :P2_SR_BUSINESS_UNIT= 'TB')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Telstra Wholesale'
                       )
                  AND :P2_SR_BUSINESS_UNIT= 'TW')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Telstra Enterprise and Government'
                       )
                  AND :P2_SR_BUSINESS_UNIT= htf.escape_sc('TE&G'))
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Sensis'
                       ,'Sensis Pty Ltd'
                       )
                  AND :P2_SR_BUSINESS_UNIT= 'SENSIS')
          )
      AND :P2_SR_TIO_PRIORITY = 'Level 0'
      UNION
      SELECT 
         "VWSR_ALL_MERGED_DATA_MV"."SR_AREA" "SR_AREA", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_STATUS" "SR_STATUS", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_SUB_STATUS" "SR_SUB_STATUS", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_DATE_CREATED" "SR_DATE_CREATED", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_OPEN_DATE" "SR_OPEN_DATE", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_CLOSED_DATE" "SR_CLOSED_DATE", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_PRODUCT1" "SR_PRODUCT1", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_PRODUCT2" "SR_PRODUCT2", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_TIO_PRIORITY" "SR_TIO_PRIORITY", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_REF_NUMBER" "SR_REF_NUMBER", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_DATE_RECD" "SR_DATE_RECD", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_CIDN" "SR_CIDN", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_BUS_UNIT" "SR_BUS_UNIT", 
         "VWSR_ALL_MERGED_DATA_MV"."SR_NUMBER" "SR_NUMBER", 
         "VWSR_ALL_MERGED_DATA_MV"."SOURCE_SYSTEM" "SOURCE_SYSTEM", 
         "VWSR_ALL_MERGED_DATA_MV"."BATCH_ID" "BATCH_ID"
      FROM 
         VWSR_ALL_MERGED_DATA_MV
      WHERE trunc(VWSR_ALL_MERGED_DATA_MV.SR_DATE_RECD)=trunc(sysdate-1) 
         and VWSR_ALL_MERGED_DATA_MV.SR_TIO_PRIORITY IN (:P2_SR_TIO_PRIORITY)
      AND  (
           (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN (
                           'Business Support and Improvement'
                         , 'Finance and Administration'
                         , 'Cust Sat Simplification and Productivity'
                         , 'Project New and Customer Experience'
                         , 'Corp Strategy and Customer Experience'
                         , 'Other'
                             )
      AND :P2_SR_BUSINESS_UNIT= htf.escape_sc('BS&I'))
      OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN (
                           'Consumer'
                         , 'Consumer Telstra Country Wide'
                         , 'Customer Service and Sales'
                         , 'Offshore Sales and Service'
                         , 'TC and TCW Operations'
                         , 'Telstra Country Wide'
                         , 'Other')
      AND  :P2_SR_BUSINESS_UNIT= htf.escape_sc('TC&C'))
      OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                             (
                               'Telstra Customer Sales and Service'                   
                              ,'Telstra Program Office'
                              ,'Human Resources'
                              ,'IT'
                              ,'Unallocated'
                              ,'Other'
                             )
              AND :P2_SR_BUSINESS_UNIT= 'OTHER')
      OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                           (
                            'Telstra Operations'
                            ,'Telstra Networks and Services'
                            ,'Other'
                            )
              AND :P2_SR_BUSINESS_UNIT= 'TO')
      OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                          (
                           'Telstra Business'
                          )
              AND :P2_SR_BUSINESS_UNIT= 'TB')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Telstra Wholesale'
                       )
              AND :P2_SR_BUSINESS_UNIT= 'TW')
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Telstra Enterprise and Government'
                       )
              AND :P2_SR_BUSINESS_UNIT= htf.escape_sc('TE&G'))
         OR (VWSR_ALL_MERGED_DATA_MV.SR_BUS_UNIT IN 
                       (
                        'Sensis'
                       ,'Sensis Pty Ltd'
                       )
              AND :P2_SR_BUSINESS_UNIT= 'SENSIS')
         )
      AND :P2_SR_TIO_PRIORITY = 'Level 1'
      Edited by: user13653962 on 30/01/2013 15:11

      Edited by: user13653962 on 30/01/2013 15:14