How to execute Oracle Function from Python Script Python programming

YOUR LINK HERE:

http://youtube.com/watch?v=ghx9gOFnibQ

This is the ninth video of Database programming with Python video tutorial series. In this video we will see how to connect to the Oracle database using the cx_oracle package and execute oracle functions using the callfunc method, we will see how we can pass parameters to the function from python script, and store the result back into a python variable. • How to execute an Oracle Function from Python Script? • result = callfunc(function_name,output_variable, parameters) • The returnType parameter for callfunc() is expected to be a Python type, one of the cx_Oracle types or an Object Type. • Steps performed: • ================ • Create Connection • Create Cursor • execute the function with callfunc • close the cursor • close the connection • The cx_Oracle is a Python extension module that enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions. • cx_Oracle 7 has been tested with Python version 2.7, and with versions 3.5 through 3.8. You can use cx_Oracle with Oracle 11.2, 12, 18 and 19 client libraries. Oracle's standard client-server version interoperability allows connection to both older and newer databases. For example Oracle 19c client libraries can connect to Oracle Database 11.2. • • Links to all videos related to Database programming with Python • ================================================================= • 1. Install cx_Oracle : • Python | How to Install python packages • 2. Create connection and create table : • Python Programming | Connect to an Or... • 3. Insert record into the table with execute() : • Python programming | Insert data into... • 4. Insert multiple records into the table with executemany() : • Python programming | How to insert mu... • 5. Retrive all the data from the table using the fetchall() : • Python programming | Select or get da... • 6. Retrive one record from the table using the fetchone() : • Python programming | Select or get da... • 7. Retrive specific number of records from the table using the fetchmany() : • How to read data from table in python... • 8. Use Bind Variables in the select statement to avoid complicating the query with concatenation operation : • Python programming | Executing SQL qu... • 9. use callproc method to execute oracle procedure with parameters : • Python programming | How to execute O... • 10. use callfunc method to execute oracle function with parameters : • How to execute Oracle Function from P... • • Tools used in creating and executing the scripts: • ================================================== • VSCode - Visual Studio Code • SQL Developer • Links used while creating the content: • ======================================= • https://en.wikipedia.org/wiki/Pip_(pa...) • https://oracle.github.io/python-cx_Or... • https://github.com/oracle/python-cx_O... • Subscribe to the channel : / @kishanmashru • Other Playlists: • Data Warehousing Concepts: • Data Warehousing Concepts • Python and Database: • Python | How to Install python packages • SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS • SQL and PL/SQL concepts: • SQL and PLSQL • Content and video created by : Kishan Mashru

#############################

New on site