Hi Friends,
I have following requiremnt
Background
I have 12c DB running with stored procedures and tables for the front end application running on WebLogic server. I wanted to replace an existing functionality with APIs approach .
Existing Program : Upload the csv files with sqllloader to 12c tables (stage tables) and then a ksh (scripting) program will validate the exported data and uploaded to the base tables from stage table.
Since it is Oracle 12c , from my internet search it is found that with ORDS functionality we can replace the existing program (the one described above) in the form of API. And the same APIs can be exposed to other team where they send the csv to us.
The actual question ?
Since I have a 12c DB running how can I enable/install the ORDS. From the internet search I am little confused with stand alone installation / application server installation . Can somebody help me to clarify the below
1.Can we install the ORDS in 12c Running DB ? I don’t want to create any new PDB (new DB instance) for the ORDS to enable ?
2.Do I need to install something in DB server ? What should I tell to our DBA to enable the ORDS in 12c DB
3.Once the DBA completes their steps in DB server , how can I enable the same in sql developer to start building the API?
4.Once the ORDS service is running in DB servere , what is the point of running in weblogic server ?
5.Finally , the people who have licensed Oracle 12c , do we need to take any other license to use the ORDS ?
Thanks
Shamid