Current position:Home > getstatusoutput sqlplus python

getstatusoutput sqlplus python

Advertisement

Can I just issue sqlplus command like a Korn shell does in python?

-0001-11-30

Hi I have a question on python as an Oracle DBA. Do I have to have cx_oracle or another similar compenent in order to access Orade database? Can I just do sqlplus like a Korn shell does? I am an Oracle DBA. Daily job requires shell scripting. I am sk

How to - Run SQLPlus and script in Python ?

-0001-11-30

I want to have Python run command like this (on Windows) - and wait for completion "sqlplus.exe myname/[email protected] @C:\Temp\test.sql" commands module does not seem to work, and subprocess module just launches sqlplus. How have you done this ? th

Sqlplus can connect but can not work!

-0001-11-30

I have finished an installing of an Oracle10R2 on the OEL5.0 system. All run well except that the sqlplus can not work.I install it once more, but the results are same. What is the problem? [[email protected] database]$ sqlplus SQL*Plus: Release 10.2.

UnixODBC with sqlplus? or just instantclient only?

-0001-11-30

Hi I was hoping to connect to an Oracle 10g (I think) instance from a python script on CentOS. So far I have figured out that python needs the PyODB sourceforge module which in turn needs the unixODBC and unixODBC-devel packages. I already have sqlpl

Error in starting sqlplus

2015-10-11

Initializing first test to use userid: scott, password: tiger Attempting to connect using userid: scott The test did not succeed. ORA-12541: TNS:no listener There may be an error in the fields entered, or the server may not be ready for a connection.

Can not open sqlplus on Oracle10g/OEL5.0

2015-10-11

I have installed an Oracle10g database on the OEL5.0 system (not encounter any errors) today. But after finishing the installation, I can not login the sqlplus. [[email protected] ~]# sqlplus bash: sqlplus: command not found. When I loged in to the Data

SQLPLUS prompt in one row

2015-10-11

Hellou I need help in SQLPLUS. I need to prompt into the file one row of information like this: 0000004202;;00151564;[email protected];160120071333 this -> 0000004202;;00151564;[email protected]; is just static text this -> 160120071333 is date in f

Unable to capture stdout, stderr from python.

2015-10-11

I am trying to read the stdout and stderr of a python program. When I invoke anything else apart from python my class works fine. The python program takes ca 1 sec to start. It then prints one line of text, then it prints a promt and waits for input

SQLPLUS commands in SQL Developer

2015-10-11

We are using 11g with Sql Developer. We have some script such as healthcheck etc provided by oracle support, which has SQLPLUS commands in it. We are not able to run those in SQL Developer. We are getting errors. Are there any way, we could invoke SQ

Calling a .py script inside a .VI, using anaconda's Libraries or specific python version (SystemExec.vi(?), MAC OSX)

2015-10-11

Hi, I'm new to both mac and LabView, so it may well be something obvious I'm missing. I'm trying to use System Exec (http://zone.ni.com/reference/en-XX/help/371361L-01/glang/system_exec/ with LabVIEW 2014 on Mac OS X Mavericks) to call a python scrip

USB 6009 Python Control

2015-10-11

 Hello,  I am attempting to use python (with ctypes) to control my USB-6009.  The goal is to write out an analog voltage and then read in the voltage through an analog input with ability to change the number of points averaged and the number of times

USB-6009, mac OS 10.6.8 and python

2015-10-11

Hello! I am using USB-6009 under mac OS 10.6.8 and python. I am trying to run the following commmand: analogOutputTask = nidaqmx.AnalogOutputTask(name='MyAOTask') I get the following message File "/Applications/PsychoPy2.app/Contents/Resources/lib/py

Sqlplus fails to start, halting Ora10g install on WinXP

2015-10-11

Hello, I've been trying to install Oracle 10g 10.2.0.1 on Windows XP SP2 all day. The problem is, sqlplus crashes (creating a Windows app crash dialog) during the Oracle Database Configuration Assistant step. Clicking "Don't Send" on the crash w

Getting sqlplus and odbc connection to work

2015-10-11

I'm looking to automate some data extraction activities either through a windows batch file or set up a data connection in an excel spreadsheet. I've installed (I think) the instant client, but, I'm not seeing any programs to run in my start>All Prog

Sqlplus and sqlldr commands getting hanged and utilizing cpu to 100%

2015-10-11

Hi , We have a server in which only 10.2.0 client has been installed to execute some scripts in other databases. From today morning we are having problem to run sqlplus or sqlldr . whernever sqlplus or sqlplus /nolog is given it just getting hunged.T

[SOLVED] tv_grab_nl_py works with python 2.6.5, fails on 3.1.2

2015-10-11

Hi All, I have updated my mediacenter. Now tv_grab_nl_py does not work anymore: [[email protected] ~]$ tv_grab_nl_py --output ~/listings.xml --fast File "/usr/bin/tv_grab_nl_py", line 341 print 'tv_grab_nl_py: A grabber that grabs tvguide data from tvgi

How can I retrieve values from integer array in sqlplus?

2015-10-11

I'm trying to write a query against OEM grid tables to come up with the result to show all scheduled backup jobs, in OEM grid, there is a table sysman.mgmt_job_schedule, one of the column DAYS is defined as TYPE SYSMAN.MGMT_JOB_INT_ARRAY AS VARRAY(50

Compability problem with Java and Python  RSA algorithm implementation

2015-10-11

I have client server application. Server is writtein in python, client in java. Client receives messages from server encrypted with RSA (http://stuvel.eu/rsa), and I'm unable to decrypt it. It seems that this is RSA algorithm compatibility problem. I

Sqlplus exit with bind variable gives error

2015-10-11

Hi, I want to return the ID-value from an insert-statement back to the OS, but I can't catch it properly in a variable to exit that variabel. here's the script: variable logid NUMBER; select id_seq.nextval into :logid from dual; -- insert into Tab_A

Exit with bind variable from sqlplus and then echo $?

2015-10-11

Hello world. I don't know why they are different between :v_num and the value of "echo $?" thanks. SANOWT:oratest:/data3/oratest/oratest/hgjung> cat t.sql select count(*) from all_objects; variable v_num number; begin select count(*) into :v_