I need to connect to Oracle database to run sql queries from SOAPUI Pro within Ready!API.
I selected oracle Thin/oracle.jdbc.driver.oracleDriver in Database Configuration.
However, I have to enter service-name instead of SID, but I donot see that option in dbase configuration settings. Please help
Hi, Thanks for your reply.
In our database connection properties, we no longer use SID, we specify service-name.
That is how we connect even using SQL Developer.
I have to use service-name to connect instead of SID to connect to database.
I tried putting service-name value in SID field in connection details of SOAPUI Pro, but connection failed.
Please advice. Thank You.,