APEX schema problem

user4049807

Hi,

I'm new in APEX and I got a problem with my schema. I have an existing database with lots of data, lots of table. These tables owned by one schema. When I try to create an application using that schema and I select an existing table, I get the following error message:

"Ajax call returned server error ORA-20987: APEX - Invalid schema name - Contact your application administrator. for Execute Server-Side Code."

Is there any settings (grants, privilege, etc.) for a schema that makes it to not working? What should I do? Is there any solution to fix this schema or is it possible for another schema to use this schema's tables for creating APEX applications?

Thanks for the answeres!

Andrew

fac586

What is the problematic schema name?

user4049807

The schema name is: WORK

fac586

The schema name is: WORK

WORK is an Oracle keyword and therefore a poor choice of identifier that is likely to cause problems.

What is being entered as the table name in the page wizard? All that is visible in the screenshot is T. proba, which appears to have nothing to do with the WORK schema and isn't a valid identifier.

Please do not attempt to describe problems using screenshots—especially cropped, context-free ones. These are not accessible to visually impaired members of the community, cannot be indexed by search engines, or copied/pasted to reproduce the problem. If you must post screenshots (primarily to demonstrate layout and presentation problems that cannot be reproduced on apex.oracle.com), post the entire window to preserve context.