This content has been marked as final. Show 3 replies
It is possible the pl/sql engine in forms is not recognizing coalesce function. To be honest I haven't tried it. If that is the reason the simplest solution is to create database view and in forms you simply query that view.
Hi, thanks for your answer,
i think pl/sql in a form recognize Coalesce because i used it in a form inside DBMS text query execution. but if i try to use it with a CURSOR, i get the error. Same thing with VLM.. that strange a bit!
my query works if i don't use CURSOR, if i use it, it doesnt works.
thanks for your help.
have a nice day
Neimad wrote:I don't know what that means or is, probably Dynamic SQL?!?
DBMS text query execution.
Anyway; coalesce doesn't seem to be the problem, your correlated subquery however is:
select coalesce(1,2) into dummy from dual;
does not compile.
select coalesce(1,2), coalesce((select 1 from dual), 2) into dummy from dual;
reason and solution is the same as already stated: the forms PL/SQL engine simply doesn't know correlated subquerys, and if you use a view you will be able to use a correlated subquery. Or you simply could rewrite your query to not use correlated subqueries.