APEX

Hi, guys.

Here is what i try to do:

Create a region of type SQL Query (PL/SQL function body returning SQL query). In the source area i tried to put this:

DECLARE

v_new VARCHAR2(10);

v_SQL varchar2(32000);



BEGIN

v_new := :P102_HDN_NEW;

-- htp.p(v_new);



IF v_new = 'N-Set' THEN

v_SQL := 'select ' ||

.......................

.......................';

ELSIF v_new = 'Y-Set' THEN

v_SQL := 'select ' ||

.......................

.......................';

END IF;

RETURN v_SQL;

END;



And here is the reply from APEX:

1 error has occurred

Query cannot be parsed within the Builder. If you believe your query is syntactically correct, check the ''generic columns'' checkbox below the region source to proceed without parsing. The query can not be parsed, the cursor is not yet open or a function returning a SQL query returned without a value.

###########################

Now.

1. Variable is set with the right value.
2. Each statement (separately) returns SQL that works with no problems
3. Problem occures if i try to put IF statement around the SQL creation.
4. If i select "Use Generic Column Names (parse query at runtime only)" instead of "Use Query-Specific Column Names and Validate Query" then the script returns SQL properly, however report's column names are set to Col1, Col2,Col3 ......

Thnks in advence

Mike