Python Forum

Full Version: Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi Team,

We are having a data warehouse project which is written in Oracle PL/SQL.
Now we are transferring it to SNOWflake but since Snowflake don't support PL/SQL Packages, Procedures & Functions.
SNOWFlake support either Java Script procedure or we can use Python modules.
So, is there a way to convert PL/SQL code like Packages, procedures, Functions or objects, Nested tables, Varrays to respective Python code.

Thanks in advance for any pointers in the right direction.
Have you seen this Oracle document: https://community.oracle.com/docs/DOC-1007065
seems to go step by step with PL/SQL example followed by python for same.
Hi Divya,

I'm now in the exact same boat as you were in Converting Pl/SQL Packages into Python.

How did you tackle that? How was your project went live?

May i please have your email id to clarify my doubts.

your help is greatly appreciated.


Thank you
Srikanth