The problem of data output from a stored function in apex. Who will help?

Created object of type report.
in this query:

If so
SELECT 
IDGDN
 FROM TABLE(#OWNER#.SELECT_DATA_ALL
(
 TO_DATE('27.01.2017','DD.MM.YYYY'), 
TO_DATE('27.01.2017','DD.MM.YYYY'))
 )


Error:
failed to parse SQL query:
ORA-06575: Package or function SELECT_DATA_ALL in the wrong state

If so
SELECT 
IDGDN
 FROM TABLE(DK.SELECT_DATA_ALL
(
 TO_DATE('27.01.2017','DD.MM.YYYY'), 
TO_DATE('27.01.2017','DD.MM.YYYY'))
 )


Error:
failed to parse SQL query:
ORA-00904: : invalid identifier

The application itself runs under sales.

If this request to launch dbForge Studio for Oracle, everything is OK
August 19th 19 at 23:00
0 answer

Find more questions by tags Oracle Application ExpressSQL