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
3
votes
2answers
59 views

How to create index to improve performance of an aggregate function that creates a table in oracle

I am creating an Oracle ORDS API using APEX_JSON. I recently started using bind variables instead of string concatenation using ||. I am trying to use an in clause in my where condition. The problems ...
0
votes
0answers
37 views

Trigger to loop and send incremental email based on condition [duplicate]

I have a requirement in Oracle apex to implement dynamic approval workflow in issue tracker. I am trying to write a trigger for the same as below. I need to further modify it so that it runs ...
0
votes
0answers
143 views

Oracle Apex: catcon::wait_for_completion: unexpected error in next_proc()

I am trying to install oracle apex 19.2 on Oracle 18C XE edition . But while installing I am getting below error message after running @apexins.sql sysaux sysaux temp /i/ catcon::wait_for_completion:...
0
votes
1answer
28 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
351 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
628 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
355 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
186 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
189 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 ...
2
votes
1answer
640 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
72 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
201 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
959 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
314 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
463 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
639 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
7k 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
526 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 mocking up some options for a simple, internal reporting front-end for an Oracle database. I have Oracle XE 11R2 on a separate testing machine, and am going through a tutorial on making a simple ...
1
vote
1answer
328 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
44 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
5k 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
3k 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
549 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
416 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
412 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
307 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
45k 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. ...