从Oracle调用Python [英] Calling Python from Oracle

问题描述

是否可以在Oracle过程中调用Python?我已经读了很多有关相反情况的文献(从Python调用Oracle SQL)，但反之则没有.

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.

我想做的就是让Oracle产生一个数据库表，然后我想调用Python并将该数据库表传递给DataFrame中的数据表，以便我可以使用Python对它做一些事情并产生结果.在Oracle过程中，我可能需要多次调用Python.有谁知道这是否可行以及如何实现?

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?

推荐答案

您可以使用Java运行Python代码，您可以将两者结合起来以实现您想要的.

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.

这篇关于从Oracle调用Python的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！