Skip to content

evrimulgen/python_plsql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

75 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Description

Right now it's use is only academic, however potential applications would be to make testing PL/SQL easier by providing a simple way to call them from an easy to use language

How to use this right now?

What you need is just the client.py file, the cx_Oracle package (refer to it's documentation on how to install it) and an Oracle database you can point this script to.

NB! Current version has a modified version of cx_Oracle, so this package currently will not work for you

Example(s)

Hopefully if all goes well you will be able to call most of the PL/SQL code from Python

>>>plsql = Database(...):
>>>plsql.simple_function(p_int=5)
10

Refer to tests for what is being supported right now, it is not a lot, but enough for a proof of concept (Creating an easy way to call PL/SQL from Python)

About

Allows use of PL/SQL function/procedures from Python

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors

Languages

  • PLSQL 58.7%
  • Python 41.2%
  • PLpgSQL 0.1%