Questions tagged [oracle-apex]

Oracle APEX (Application Express) is a rapid application development environment for creating web-based applications that access Oracle databases.

Filter by
Sorted by
Tagged with
0
votes
1answer
20 views

Creating a database link from Oracle Cloud server to remote access database

I work for a small company that currently use Apex to run reports on our accounts system. Oracle is installed on our local server and part of the data is gained via a database link to an access ...
1
vote
1answer
191 views

APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created

I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an ...
1
vote
0answers
522 views

How to solve problem when oracle apex does not let me do anything with my created schemas even though I should have privileges?

I have a problem with with latest version of APEX, I have installed it on my pc, i logged in as and admin created workspace with schema, but when I log in to that workspace as a user with admin's ...
1
vote
1answer
264 views

Falied to load resource files of Oracle APEX plugin

I've installed a plugin in APEX, but when I've tried to use it on a page, I've got some nasty errors and page not working properly. The files are present in the plugin settings: But, as you can see ...
0
votes
0answers
165 views

Connect to Oracle database as apex_version user

I'm talking about schemas like APEX_040200, APEX_050100, APEX_180300, APEX_190100 etc. I'm trying to install an APEX Plug-in that is being installed from a script, where developper commented Assumes ...
0
votes
0answers
135 views

Reference apex_workspace_apex_users or wwv_flow_fnd_user in a foreign key constraint

What I'm trying to do is to extend authorisation upon APEX basic users to use it as conditions of pages rendering. I would like to create additional tables to store some workspace specific info about ...
1
vote
1answer
488 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
0
votes
1answer
70 views

Switching alias in subquery equality leads to different result

Trying to learn sql queries recently and as the title says I stumbled upon some "behavior" i didn't understand. This query returns the managers from the database. SELECT * FROM employees e WHERE ...
1
vote
0answers
188 views

Oracle Apex IR subscription not working

I have configured apex instance to use smtp email, and I can send email with IR when using download option from action menu. But the IR subscription is not sending emails. I have checked there is no ...
2
votes
0answers
840 views

Changing a JSON object parsed with APEX_JSON

I would like to be able to change a JSON object parsed with the APEX_JSON.parse() function, but I found nothing in the official documentation, no tips or examples about that. In the code below I ...
0
votes
1answer
2k views

Can not install oracle apex on GNU/Linux (db 12c)

I have to install oracle apex on oracle database 12.2.0.1.0, database is on GNU/Linux server. I followed instructions from this pages: https://oracle-base.com/articles/misc/oracle-application-express-...
1
vote
1answer
283 views

Grant user error

Within oracle apex 5.1.2 I have been experimenting with security features relating to grants, using the managing user tab i managed to create users and allocated these users end-user account types. My ...
-1
votes
2answers
441 views

How should I ask the IT to enable publishing an apex application on Internet? [closed]

I made an application in apex, (I barely learning first steps), which I use for testing. I have both the database and apex installed on my work PC, and the company has his own Oracle database ...
1
vote
0answers
1k views

Oracle APEX 5.1 connect to remote db using JDBC and query data

I have only used db links to get access to remote db so far. Now I have to find a way to use JDBC to connect to remote db and get data. Can someone guide me what all things would I need to ask the ...
0
votes
1answer
589 views

APEX Installation ORA-01435 while running @apxconf [closed]

I'm trying to configure and use APEX on a Oracle Database 12c. When I try to run @apxconf I get the Error ORA-01435. I don't really now what is wrong since I followed the Documentation. https://docs....
1
vote
1answer
6k views

Using NEXT clause to set periodic materilized view refresh in oracle and verifying refresh

I am not able to find the right documentation on setting specific timings for materialized view refresh for oracle. I read up the documentation and some examples there, however there is no definite ...
0
votes
1answer
515 views

Upgrade Oracle APEX 4.0.2 to 5.1.1 error

I installed Oracle 11g XE on CentOS 7 and everything went fine. I wanted to upgrade APEX to the latest version and followed instructions in Upgrading Oracle Application Express within Oracle Database ...
3
votes
1answer
3k views

How does Oracle Application Express connect to the database?

I'm a non-DBA (public works guy) mocking up some options for a simple, internal reporting front-end on an Oracle database. I have Oracle XE 11R2 on a separate testing machine, and am going through a ...
1
vote
1answer
300 views

Why does Oracle APEX Shared_Servers = 0 Break Apex 3.2

Installed APEX 3.2 and set the shared_servers = 5 and APEX works great, but breaks other processes with our DB. So I set the shared_server = 0 again and now APEX won't show. I'm using Oracle 11g and ...
0
votes
1answer
43 views

How to know max specified memory in Oracle XE11g release 2?

What is the max specified memory in Oracle XE11g release 2? I have read in Oracle documentation that the allowed max memory for database is 1GB RAM. Is that per database or per session? And if it is ...
0
votes
2answers
2k views

Composite Attributes in apex oracle [closed]

I am learning database in apex oracle. Now I am trying to create table. I Have composite attributes, but I cannot implement on db. CREATE TABLE PERSON ( FIRSTNAME VARCHAR2(15) NOT NULL, ...
4
votes
1answer
6k views

How to get Page Name given Page ID in Oracle Application Express

Prefix: I have looked all over the net for this answer. Let me prefix the question by describing what I am trying to do: I am trying to create a unique list of shortcuts to pages in my application for ...
1
vote
2answers
4k views

APEX 5: Horizontal Scollbar on page instead of region [closed]

I'll generate in APEX 5 (Universal Theme) a large table with PL/SQL Dynamic Content. To scroll down, there is a scrollbar on the page. To scroll to the right, there is only a scrollbar in the region/...
1
vote
1answer
2k views

Problem using sample schemas by Oracle in Oracle APEX

I am new to Oracle and Oracle APEX. I have been practicing to make Oracle APEX database application using "hr" schema of the database. Before doing so, I unlocked the schema, along with schemas "scott"...
1
vote
1answer
5k views

APEX 5: Page item (Select List) with LOV must have values from a another table which return PK (FK of current table)

I have a page form where the user can make a new account. Every user has a type. The user must choose which type of user it is. I have two tables (Users and UserTypes). What I want to do is user must ...
1
vote
0answers
340 views

Oracle Application Server Integration With APEX

This might not be directly related to DBA, if so kindly advise. I need to integrated some reports created via Oracle Reports Builder with APEX. Reports are in RDF format. Which version of Oracle ...
2
votes
0answers
535 views

How do I authenticate a Database User by a LDAP Server and then to login with the SQL Developer, without using the OID/Apex?

I want to create a global User, identified by a LDAP_DN. My Problem is: I can automatically create users, but when I try to log on to the database, I get the error message that the login data are ...
2
votes
1answer
415 views

Oracle Application Express Listener PDF Report

We need our reports to be available in PDF format on our Oracle 11g, APEX:4.2.6 Followed this tutorial and selected "Oracle APEX Listener". But the generated PDF report is empty. We are using EPG. ...
1
vote
1answer
1k views

How to create DBA user from oracle APEX 11gR2 XE

Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)? I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle ...
1
vote
1answer
2k views

How to access apex data from sqlplus?

I have setup an oracle database in my Ubuntu machine. Now I have took the following steps to create tables 1) login to my ubuntu account 2) su oracle 3) sqlplus "sys as sysdba" //Connected to an ...
0
votes
0answers
1k views

How do I connect to oracle apex server through JDBC ?

I have got a workspace in apex.oracle.com , Now , I want to connect to that database through JDBC from ubuntu-14.04 machine. please explain the steps , From where should I download the drivers and ...
1
vote
0answers
411 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
1k 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
0answers
303 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 ...
1
vote
0answers
2k 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
7k 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 ...
4
votes
3answers
44k 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. ...