topic Re: How to Call Oracle Stored Procedures from Databricks? in Data Engineering

How to Call Oracle Stored Procedures from Databricks?

Raghu101 — Mon, 26 Dec 2022 10:53:29 GMT

How to Call Oracle Stored Procedures from Databricks?

Re: How to Call Oracle Stored Procedures from Databricks?

Meghala — Mon, 26 Dec 2022 11:13:47 GMT

here i have code

val url =
"jdbc:mysql://yourIP:yourPort/test?
user=yourUsername; password=yourPassword"
val df = sqlContext
.read
.format("jdbc")
.option("url", url)
.option("dbtable", "people")
.load()

Re: How to Call Oracle Stored Procedures from Databricks?

jonathan-dufaul — Fri, 30 Dec 2022 23:52:17 GMT

Chiming in because I don't know if the above quite answers how to execute a stored procedure. I use PySpark. I believe this should work for oracle, but only was able to test it with MS Sql Server. I had to truncate a table, but the code works for a stored procedure as well.

https://stackoverflow.com/questions/74439747/is-there-a-way-to-just-truncate-a-remote-mssql-table-from-databricks

General idea is to get the jdbc connection from the jvm gateway and use that to execute sql commands.

sqlSurl = "jdbc:[driver]//ip..."
 
  con = (sc._gateway
          .jvm
          .java
          .sql
          .DriverManager
          .getConnection(sqlsUrl, \
            username, \
            password)
    )
  con.prepareCall(query).execute()
  con.close()

Re: How to Call Oracle Stored Procedures from Databricks?

AdrianLobacz — Thu, 05 Jan 2023 12:29:40 GMT

Check this link, maybe it will help you solve this problem

https://stackoverflow.com/questions/60354376/how-to-execute-a-stored-procedure-in-azure-databricks-pyspark

Re: How to Call Oracle Stored Procedures from Databricks?

sher — Fri, 06 Jan 2023 05:40:39 GMT

https://datathirst.net/blog/2018/10/12/executing-sql-server-stored-procedures-on-databricks-pyspark/

try this link. this may help you

Re: How to Call Oracle Stored Procedures from Databricks?

Meghala — Sat, 14 Jan 2023 08:16:00 GMT

Thanks it helps me as well

Re: How to Call Oracle Stored Procedures from Databricks?

Meghala — Sat, 14 Jan 2023 08:16:24 GMT

It was needed me as well so thanks

Re: How to Call Oracle Stored Procedures from Databricks?