user1767593 wrote:Please make sure that you have defined a LOV in your application (Shared Components -> List of Values) with the name "mmi".
select apex_item.hidden (1, null) || apex_item.text(2, null)
, apex_item.text(3, null)
, apex_item.text(4, null)
, APEX_ITEM.SELECT_LIST_FROM_LOV(5,null,'mmi',NULL,'NO',NULL,null,null,null,'NO') as testing
this trows me an error:
[Error] Execution (6: 11): ORA-20001: Query must begin with SELECT or WITH
ORA-06512: at "APEX_040100.WWV_FLOW_ASSERT", line 289
ORA-06512: at "APEX_040100.WWV_FLOW_UTILITIES", line 6554
ORA-06512: at "APEX_040100.WWV_FLOW_ITEM", line 1265
ORA-06512: at "APEX_040100.HTMLDB_ITEM", line 480
ORA-06512: at line 1
cant figure out why.. trying it in toad. i need this for a tab. form report. so i can add new lines.