Hi
using apex 5.1.1 and 11g
I have a interactive grid and one of the column there is is LOV with source as function returning sql query
I'm calling the below function
get_lov(id in varchar2,ltype in varchar2,l_cycle in varchar2)
get_lov(&P43_PROJECT_ID.,null,
&P43_BUDGET_TYPE.,&P43_CYCLE_ID.);
values that get passed to function are as follows
28490,null,20007,2017.Q3
however its throwing error due to .Q3 saying symbol Q3 encountered
Format of cycle id cannot be changes .it working fine on lovs on Forms.
issue is only here in IR.
have also tried to enclose with single and double quotes
error details below when enclosed with double quotes
Error during rendering of region "Grid Edit".
ORA-06550: line 2, column 13: PLS-00201: identifier '2017.Q3' must be declared ORA-06550: line 1, column 45: PL/SQL: Statement ignored
Technical Info (only visible for developers)
- is_internal_error: true
- apex_error_code: APEX.REGION.UNHANDLED_ERROR
- ora_sqlcode: -6550
- ora_sqlerrm: ORA-06550: line 2, column 13: PLS-00201: identifier '2017.Q3' must be declared ORA-06550: line 1, column 45: PL/SQL: Statement ignored
- component.type: APEX_APPLICATION_PAGE_REGIONS
- component.id: 88856355225975501
- component.name: Grid Edit
- error_backtrace:
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1445 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_050100", line 474 ORA-06512: at "APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS", line 997
- error_statement:
declare function x return varchar2 is begin get_lov(26543,null, 20007,'',0,"2017.Q3"); return null; end; begin wwv_flow.g_computation_result_vc := x; end;
Stuck here.please assist.
thanks
Archana