Calling Python from Oracle

python sql oracle pandas cx-oracle
user3311225 picture user3311225 · Mar 21, 2014 · Viewed 9.7k times · Source

Is it possible to call Python within an Oracle procedure? I've read plenty of literature about the reverse case (calling Oracle SQL from Python), but not the other way around.

What I would like to do is to have Oracle produce a database table, then I would like to call Python and pass this database table to it in a DataFrame so that I could use Python to do something to it and produce results. I might need to call Python several times during the Oracle procedure. Does anyone know if this is possible and how could it be done?

Answer

dwurf picture dwurf · Mar 26, 2014

You can write stored procedures in Java and you can use Java to run Python code, so you can possibly combine the two to achieve what you want.

Related questions

cx_Oracle: How can I receive each row as a dictionary?

By default, cx_Oracle returns each row as a tuple. >>> import cx_Oracle >>> conn=cx_Oracle.connect('scott/tiger') >>> curs=conn.cursor() >>> curs.execute("select * from foo"); >&…

Read More
How can I make cx-oracle bind the results of a query to a dictionary rather than a tuple?

Here is my code. I would like to find a way to have results from a query returned as a list of dictionaries rather than list of tuples. It seems like cx_oracle supports this with parts of the documentation …

Read More
Connecting to Microsoft SQL server using Python

I am trying to connect to SQL through python to run some queries on some SQL databases on Microsoft SQL server. From my research online and on this forum the most promising library seems to be pyodbc. So I have …

Read More