My Oracle Database cannot currently handle TLS 1.2 needed to communicate with Office 365 for mail. So I am using an old mail server to send out my mail because it does not need authentication and is located on premise. For internal communication I need to alter all "to" addresses to change the domain so the mail is sent to Microsoft and not back to the internal mail server.

Example: I need to change all emails from user@domain.com to user@domain.onmicrosoft.com. Is there a way I can alter the APEX_MAIL package in Oracle so that any use of domain.com in the "TO" field will automatically change to domain.onmicrosoft.com?

Alter APEX_MAIL package

How can I run Oracle APEX application on Client PC which is connected remotely to Database server side PC through Oracle Client Service software.

Oracle XE 11.2g
Oracle APEX version 19
Client service sotfware version 21.1.

Davies Mohanty The Apex Application is running on the client-side pc... thanks for your help :)

To run an Oracle APEX application on a client PC connected remotely to a database server-side PC, you need to ensure that the necessary components are properly installed and configured. Here's a general overview of the steps involved:

1. Install Oracle Client software: On the client PC, install the Oracle Client software version 21.1. This software includes libraries and utilities required for connecting to and interacting with the Oracle database server.

2. Configure the Oracle Client: Once the Oracle Client software is installed, you need to configure it to establish a connection to the remote Oracle database server. This involves specifying the appropriate connection details, such as the server address, port, and service name or SID.

3. Install and configure Oracle XE: On the database server-side PC, ensure that Oracle XE 11.2g is properly installed and configured. This involves setting up the database instance, creating the necessary users and schemas, and configuring network access if required.

4. Import the APEX application: Using the Oracle APEX web interface or SQL Developer, export the APEX application from the source environment and import it into the Oracle XE database on the server-side PC. This process typically involves exporting the application as a SQL file and executing it on the target database.

5. Configure APEX authentication and access: Within Oracle APEX, configure the appropriate authentication method (such as database users or LDAP) and set up the necessary user accounts and privileges to access the application.

6. Configure network connectivity: Ensure that the client PC has network connectivity to the server-side PC running the Oracle database. This may involve setting up firewall rules, configuring network address translation (NAT), or using a virtual private network (VPN) if necessary.

7. Access the APEX application: On the client's PC, launch a web browser and enter the URL for the APEX application, specifying the appropriate server address and port. For example, if the application is running on the server-side PC's localhost at port 8080, you would enter something like http://server_address:8080/apex.

By following these steps, you should be able to access and run your Oracle APEX application on the client PC connected remotely to the database server-side PC. Keep in mind that the specific configuration and setup may vary depending on your environment and requirements, so it's recommended to refer to the relevant documentation and resources provided by Oracle for detailed instructions.

How to run Oracle APEX application on Client side PC

I'm new in oracle apex and I am seeking to make a custom authorization for the user login to the software. I have made a custom authentication for the log-in usage of this pl/sq. Code

 -- Validate whether the user exists or not

 WHERE upper("user_name") = UPPER (p_username) AND password = p_password and status='Active'

However once I want to login the use of this i need to assign the consumer in "software get right of entry to manipulate". How to make the user can login with out manually assign the user to application access control? Or how to make custom authorization for the consumer to login to the software?

How to login to application after assigning user using custom authentication in Oracle Apex

I'm growing a database software in oracle utility express (apex) with the aid of the usage of the application builder and I have a short question regarding paperwork and reviews. I know how to create simple forms and reviews but I'm aiming to do something a little more difficult. I need the user to be offered a shape with the fields username and password, and after inputting the username and password I want the shape to crosscheck the username and password inputted against a 'scholar' desk that I created with sq. And if it exists then I need the software to then deliver up a document with the applicable subject containing this data.

As an instance a user inputs 'hello' as their username and 'letmein' as the password through the form and then if it exists in the scholar table the software will then permit them to peer the whole row of information for their particular scholar account only. The cause I want to do it this manner is that I want the students to handiest be able to see their particular row of facts and not any other pupil rows inserted in the 'scholar' desk glaringly because of privateness motives.

I tried to apply the question on shape option while growing a brand new page for the application however it only we could me as the developer put in the question assertion and that I cant do that because it must be specific to whatever the user inputs within the 'username' and 'password' subject at the form themselves.

Wish it makes feel as I have tried to give an explanation for in the high-quality manner viable and I've genuinely been searching for a good few hours looking for the solution however I feel there is restricted oracle utility explicit fabric available on sites like youtube which I commonly usually seek advice from while gaining knowledge of something new. I've additionally regarded inside the oracle utility explicit user doctors but there is nothing that I'm able to find that allows me to attain the results I'm seeking out.

Oracle Application Express - Forms And Queries

I am growing a small ERP in oracle apex 18.2 I need to enforce custom security as indexed under

1) person must authenticate from a custom desk

2) after authentication person should be authorized to the application as consistent with the assigned function in custom desk

3) the consumer should have been authorized for study, insert, replace and delete operation from the desk

oracle apex 18.2 custom authentication and authorization

Here I've created many apex database packages. Now I have unique domains for every of these apex applications. Currently, I have written a redirect in each of those domain settings to my apex software. Forex.

http://www.domain1.com has a redirect URL set to http://myapexhostingserver.com/pls/apex/f?p=162:LOGIN:16888048444232

http://www.domain2.com has a redirect URL set to http://myapexhostingserver.com/pls/apex/f?p=165:LOGIN:16888048444232

A redirect isn't google pleasant. However, I cannot buy oracle net website hosting for each area too. Is there any other proper answer available?

That means, when I buy a shared web hosting server, I will create as many PHP packages as I want. But now not positive if that is also feasible in the oracle apex.

oracle-apex

Trending Blogposts on oracle-apex

Popular Discussions on oracle-apex

openAlter APEX_MAIL package

1

0

0

closedHow to run Oracle APEX application on Client side PC

2

2

0

openHow to login to application after assigning user using custom authentication in Oracle Apex

1

0

0

openHow to login to application after assigning user using custom authentication in Oracle Apex

0

0

0

openOracle Application Express - Forms And Queries

1

0

0

openoracle apex 18.2 custom authentication and authorization

1

0

0

openMake my oracle apex application point to website home page url

1

0

0

PRODUCTS

QUICK LINKS

LEGAL

oracle-apex

Trending Blogposts on oracle-apex

Popular Discussions on oracle-apex

openAlter APEX_MAIL package

1

0

0

closedHow to run Oracle APEX application on Client side PC

2

2

0

openHow to login to application after assigning user using custom authentication in Oracle Apex

1

0

0

openHow to login to application after assigning user using custom authentication in Oracle Apex

0

0

0

openOracle Application Express - Forms And Queries

1

0

0

openoracle apex 18.2 custom authentication and authorization

1

0

0

openMake my oracle apex application point to website home page url

1

0

0