Python Forum

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

(Dec-26-2018, 08:31 AM)DivyaKumar Wrote: [ -> ]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.

Converting PL/SQL code such as packages, procedures, functions, and complex objects like nested tables and VARRAYs to Python is possible using various tools. For example, Ispirer Toolkit is one option that supports automating this type of conversion. It can help translate PL/SQL logic into Python though some manual adjustments might still be needed depending on the complexity of the code.