Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Lalitha KMar 9 2015 — edited Mar 13 2015

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 10 2015
Added on Mar 9 2015
#python
1 comment
1,724 views