Please urgent help!!!, I have a procedure, but I don't know why I have the error "Invalid Identifier", my declaration is in this way:
strsql VARCHAR2 (4000);
strsql := strsql || 'SELECT * FROM TAB_FIRST WHERE ';
strsql := strsql || 'B.CODSTATUS = D.CODSTATUS AND ';
strsql := strsql || 'A.CODTODO = F.CODTODO AND ';
strsql := strsql || 'A.USERFROM = E.CODI_OPER AND ';
strsql := strsql || 'A.OPERTYPEFROM = E.TIPO_OPER AND ';
strsql := strsql || 'J.TIPO = ''A3'' AND ';
strsql := strsql || 'A.OPERTYPEFROM = J.CODIGO AND ';
strsql := strsql || 'A.CODSTAGE = G.CODSTAGE AND ';
strsql := strsql || 'A.CODSTAGE = H.CODSTAGE AND ';
strsql := strsql || 'A.PERSONTYPE = H.PERSONTYPE AND ';
........
well, is a very large query and when it has a lenght of 1250 characters the next line presents the invalid identifier error for strsql, can you help me? do you know or have any idea of what's happening? I know that the max lenght is 400 for a varchar2 type. Thanks