The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
41 views

Importing CSV Files with Date Columns

I am working on a project that involves importing data via Apex's data workshop. Two of my columns contain dates in the format YYYY-MM-DD HH:MI:SS. Can anyone tell me how to get Apex to import these ...
1
vote
1answer
78 views

PL/SQL operating system call

I'm trying to lauch a system call from Oracle Apex, directly or indirectly. It seems to only accept PL/SQL procedures, so I iterated towards this: begin :p3_request_id := sequence.nextval; ...
0
votes
1answer
42 views

503 error while trying to access my first RESTful web service

hi, i just created a RESTful web service following this tutorial , when i try to test it i get a 503 error, i read somewhere that i have to set up the apex_listener by running the ...
0
votes
0answers
80 views

Oracle APEX Button creating ORA-00920

I have a table for user registration with a column for account_status which I filled with the content from SYS.dba_users. I also have a APEX application for this table and some other stuff and want to ...
0
votes
0answers
361 views

migrate APEX to a new database with newer APEX version?

what is the best approach to migrate an APEX app to a newer version of APEX (4.2.3) on a fresh installed database on a new server? is there any straightforward step by step? I never done that before! ...
0
votes
1answer
1k views

User with dba privs can't login to APEX, but can from SQL*Plus

I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus. I just created user: CREATE ROLE administrators; GRANT dba TO ...
0
votes
2answers
7k views

How do I discover the Oracle Express workspace name?

Is there a way to discover the WORKSPACE name if I've forgotten it? I cannot login to the APEX admin console since I've forgotten what the workspace name was. I do know the SYSTEM user password. ...