Hi user12000827 (a name would be great),
I don't think "Oracle OPSS REST Service Application" is the REST layer you need to use. We are rather talking about Oracle REST Data Services .
Just recently somebody asked the same question on twitter, here is the screenshot of a sample installation and where to say yes and no:
In this sample I configured just a pl/sql gateway / connection pool (comparable to a dad) for the schema TRAINING. I did not configure APEX nor did I configure any REST services. This is the most basic setup.
A few things won't work with ORDS compared with mod_plsql, e.g.:
- File / Upload / Download (here is a workaround available since an apex upload procedure is hardcoded in ords, you can use the same procedure with the required signature in your schema)
- Custom authentication is not supported
- Prompting for username/password and authenticating against the database is not supported
Aside from that most things work and ords is definitely stable enough to move away from mod_plsql.
Hello and thank you for your update. It is very helpful.
My name is Andreas by the way.
Just to reply on your comments.
On our website we use owa_custom package with authorise function. This procedure reads a username and password from the database. Once the browsers login pops-up the user enter his credentials which are validated against the database table and he logins. We also connect this username with other tables in the database which identifies the user to us and brings his own data.
As I understand from your comments this cannot be done now. Correct. The workaround will be make a custom login page?