Python Forum
Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.
#1
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.
Reply
#2
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.
Reply
#3
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Installing python packages in a virtual environment Led_Zeppelin 1 710 Aug-15-2023, 08:18 PM
Last Post: deanhystad
  Installation of packages to newest Python version from previous one Andrzej_Andrzej 3 779 Jul-15-2023, 11:32 AM
Last Post: snippsat
  How to see the date of installation of python modules. newbieAuggie2019 4 1,461 Mar-31-2023, 12:40 PM
Last Post: newbieAuggie2019
  I need to add data types to cython conversion python to c Good_AI_User 1 970 Aug-19-2022, 07:52 AM
Last Post: Gribouillis
  Python modules for accessing the configuration of relevant paths Imago 1 1,323 May-07-2022, 07:28 PM
Last Post: Larz60+
  Encrypting Oracle Passwords / Python Library for That? bmccollum 1 2,528 Jun-11-2021, 07:59 PM
Last Post: Larz60+
  Python modules to extract data from a graph? bigmit37 5 22,189 Apr-09-2021, 02:15 PM
Last Post: TysonL
  Installing Modules / packages Oshadha 1 1,675 Feb-05-2021, 08:04 PM
Last Post: Jeff900
  Where to add own python modules in WinPython? HinterhaeltigesSchlaengelchen 1 2,239 Jan-21-2021, 07:45 PM
Last Post: snippsat
  Calling Oracle REST SQL from Python johnjacob 2 1,992 Nov-05-2020, 04:19 AM
Last Post: johnjacob

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020