Forum Stats

  • 3,768,568 Users
  • 2,252,811 Discussions
  • 7,874,624 Comments

Discussions

Script getting hang while trying to execute update command in python using cx_oracle

Lalitha K
Lalitha K Member Posts: 1
edited Mar 13, 2015 7:36PM in Python

Hi All,

My script is getting hang while executing below script and it is not throwing any error.

TEMP_PROD_cur=TEMP_PROD_schema_conn.cursor()

sql="update APP_DB_CONNECT set DRIVER=:driver,URL=:url where APPNAME=:appname and CONNECT_NAME=:connect_name"

TEMP_PROD_cur.execute(sql,{'driver':driver_name,'url':jdbc_url,'appname':app_name,'connect_name':connect_name})

TEMP_PROD_schema_conn.commit()

I tried several ways to prepare update statement to execute but the script is getting hang in all the ways.

Please help to resolve this issue.

Answers

This discussion has been closed.