L
L
likilix2017-01-30 13:43:05
Oracle
likilix, 2017-01-30 13:43:05

Data output problems from a stored function in apex. Who will help?

Created an object of type report.
it contains the 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: SELECT_DATA_ALL package or function is in invalid 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 query is run in dbForge Studio for Oracle, then everything is OK

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey, 2019-03-21
@AndreevSergP

Does the scheme not work without an alias? Is the function in a schema that is mapped to the application?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question