IF :B_CONSULTA.COD_RESP_CC IS NOT NULL THEN
AUX := AUX || ' AND VAL_SEG_ID_SUG_CTB IN (select VAL_SEG_ID from contabil.ctb_val_seg where seg_id = 4 and val_seg_resp_cc = '||TO_CHAR(:B_CONSULTA.COD_RESP_CC)||')';
END IF;
Quando tento compilar aparece a seguinte mensagem de erro:
SQL> set serveroutput on
SQL> declare
2 vtemp varchar2(10):='10';
3 begin
4 dbms_output.put_line( to_char( vtemp) );
5 end;
6 /
declare
*
ERROR at line 1:
ORA-06550: line 4, column 25:
PLS-00307: too many declarations of 'TO_CHAR' match this call
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
SQL>