Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2023 04:59 AM
statement="EXEC procedurename imputparametre , ? "
driver_manager = spark._sc._gateway.jvm.java.sql.DriverManager
con = driver_manager.getConnection(jdbcUrl, username, pwd)
exec_statement = con.prepareCall(statement)
exec_statement.registerOutParameter(1, spark._sc._gateway.jvm.java.sql.Types.VARCHAR)
df=exec_statement.execute()
# Close connections
result=exec_statement.getString(1)
display(result)
exec_statement.close()
con.close()
