Execute Python script in oracle SQL*PLUS

Question

Can anybody let me know how to execute the python script which is saved as .py file inside oracle sql*PLUS?

Thanks and regards, Santhosha

SQLPlus is a client tool for interacting with an Oracle database. What do you mean by a .py file "inside Oracle sqlPLUS"? — Jeffrey Kemp
– Jeffrey Kemp, Commented Mar 15, 2014 at 9:11
Oracle support Java, so perhaps you could use Jython, an implementation of Python for the JVM, to run your Python code. — Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні, Commented Mar 15, 2014 at 14:27

Jon Heller · Accepted Answer · 2014-03-15 15:42:55Z

1

Use the HOST command to execute an operating system command from within a SQL*Plus script:

host python your_script.py

answered Mar 15, 2014 at 15:42

Jon Heller

37.1k6 gold badges84 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amit · Accepted Answer · 2014-03-15 15:46:39Z

0

You can run external commands from sqlplus by preceding them with a !

Example:

$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 15 15:45:35 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> !python temp.py
which one do you like ? "run"
run

answered Mar 15, 2014 at 15:46

Amit

20.6k7 gold badges51 silver badges55 bronze badges

Collectives™ on Stack Overflow

Execute Python script in oracle SQL*PLUS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related