Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.

[DivyaKumar]

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.

[Larz60+]

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.

[srikanth7482]

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