declare
q varchar2( 32767 ); -- query

w varchar2( 4000 ); -- where clause

we varchar2( 1 ) := 'N'; -- indetifies if where clause exists 

begin 

q := 'select "R_ID",' || 

' "R_NUM_AC",' ||

' "R_NUM_EKG",' ||

' "R_DATI",' ||

' "R_SMENA" ' ||

' from "#OWNER#"."RASPR_AC" ' ;

if :p3_n_smena = '1'  then

w := 'n_smena = :p3_n_smena';

we := 'Y';

end if;

if :p3_n_smena = '2'  then

w := 'n_smena = :p3_n_smena';

we := 'Y';

end if;

return q;

end;

Function returning SQL query: 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. 

(ORA- 06550 : line  2 , column  1 : PLS- 00103 : Encountered the symbol "Q" when expecting one of the following: := . ( @ % ; ORA- 06550 : line  22 , column  3 : PLS- 00103 : Encountered the symbol "RETURN" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map)

Regions of this type can't be changed to a report region. To create a report, create new region using a report region type.

ORA- 06550 : line  20 , column  1 : PLS- 00372 : In a procedure, RETURN statement cannot contain an expression ORA- 06550 : line  20 , column  1 : PL/SQL: Statement ignored 

Debug:





    1 : begin 

    2 : declare 

    3 : q varchar2( 32767 ); -- query

    4 : w varchar2( 4000 ); -- where clause

    5 : we varchar2( 1 ) := 'N'; -- indetifies if where clause exists 

    6 : begin 

    7 : q := 'select "R_ID",' || 

    8 : ' "R_NUM_AC",' ||

    9 : ' "R_NUM_EKG",' ||

   10 : ' "R_DATI",' ||

   11 : ' "R_SMENA" ' ||

   12 : ' from "HR2"."RASPR_AC" ' ;

   13 : if :p3_n_smena = '1'  then

   14 : w := 'n_smena = :p3_n_smena';

   15 : we := 'Y';

   16 : end if;

   17 : if :p3_n_smena = '2'  then

   18 : w := 'n_smena = :p3_n_smena';

   19 : we := 'Y';

   20 : end if;

   21 : return q;

   22 : end;

   23 : end;