+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. (/thread-14945.html)
Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. - DivyaKumar - Dec-26-2018
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.
RE: Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. - Larz60+ - Dec-26-2018
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.
RE: Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. - srikanth7482 - Jul-09-2020
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