REP-300: Missing Right Parentesis

[victorlazari]

Speaks galera,

After converting Report 6i to 11g, some reports have stopped working, because, have the following message: REP-300: Missing Right Parenthesis.

The problem is occurring due to a parameter that is informed a list of values ??and used in Query with & in front of the parameter instead of :.
ex. 'Du', 'ct', 'cp', 'ca' - in query -> field in (¶meter)
if I remove this line, the report works normally, now Leave this line, he says there are no right parentheses.

has other reports so also, however, the parameter type is numeric, in this case, no problem occurs.

Does anyone have any suggestions of what could be?

Thanks,
Victor

[dr_gori]

Try to place a blank space inside the parentheses.
Type:

Select all

in ( &parametro )

I believe that it is considering the last parentheses as part of the variable.

[victorlazari]

Puts !! Thank you very much! That was it! I would not have identified this so early !! hehehe: -The: -O: -O

[victorlazari]

In fact, a miracle occurred at the moment, and the problem ended up coming back! Even with the spaces, nothing to work! : Oops :: Cry :: |

[dr_gori]

Try to comment on this line to see if the problem is really there.
It may be that Reports have others and the problem is elsewhere.

[RJG]

Hello, how are you?
I make a formula field with a function that returns the list of values ??

Select all

 
function filtroFormula return varchar2 is 
begin 
 return ' and c.cod_prop in('||:xparametro||') '; 
end; 
 

aí in the select I put:

Select all

select * from tprop c where &filtro