Please provide steps to connect to oracle database using katalon studio version 7.6.2
Please follow below steps to connect to Oracle database
package PackageName
import java.sql.Connection
import java.sql.DriverManager
import java.sql.ResultSet
import com.kms.katalon.core.annotation.Keyword
import com.mysql.cj.xdevapi.Statement
import oracle.jdbc.*
public class ClassName{
@Keyword
private static Connection connection = null;
//Establishing a connection to the DataBase
def connectDB(String username, String password){
String conn = 'jdbc:oracle:thin:@//......'
if(connection != null && !connection.isClosed()){
connection.close()
}
connection = DriverManager.getConnection(conn,'username','password')
return connection
}
Thanks