It gives an error on line 4 “v_where :=…”
ORA-20999: Parsing returned query results in "ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 4: ORA-00936: missing expression".
Not sure what is wrong with this block that returns a SQL statement for the Classic Report region's query? P120_COLUMNS is a Checkbox Group.
declare
v_table varchar2(30) := :P120_TABLE;
v_cols varchar2(100) := replace(:P120_COLUMNS, ':', ',');
v_where varchar2(100) := '';
begin
if :P120_WHERE is not null then
v_where := ' where ' || :P120_WHERE;
end if;
return 'select ' || v_cols || ' from ' || v_table || v_where;
end;
Using apex.oracle.com