Kbase P142352: Warning of a NULL column in an aggregate function from Oracle causes RUN STORED-PROC to fail
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/04/2009 |
|
Status: Unverified
SYMPTOM(s):
Warning of a NULL column in an aggregate function from Oracle causes RUN STORED-PROC to fail
Error 12403 appears but the execution of the code continues
Unable to execute SQL / stored-procedure, result-set #<num> error <err-num> (12403)
Unable to execute SQL / stored-procedure, result-set #1 error 31189 (12403)
Oracle warning in Dataserver log
ORA-24347: Warning of a NULL column in an aggregate function
The warning is treated as an error and no records are returned in the temp-table
FACT(s) (Environment):
The stored procedure returns a cursor and it is loaded into a temp-table,
The store procedure has a query on a view
The view uses an aggregate function
The view contains a column which calculates MAX of a joined table (sub-select)
Some records of the joined table contain null values
All Supported Operating Systems
OpenEdge 10.x
Oracle 10g
CAUSE:
Bug# OE00181807
FIX:
Modify the view and only select the values that are not null:
select grade, (select max(grade) from salarylist b where grade is not null) g1 from salarylist a