Python Forum

i have a pl/sql contents in a .sql file with some insert/update oracle sql commands in it.
Is it possible in python to call that .sql file and execute contents in it.

testdata.sql file has contents in below format:

SET DEFINE OFF;
DECLARE
BEGIN
update tbl1 set UPD_D = to_date(sysdate-1,'DD-MON-RRRR HH24:MI:SS');
update tbl2 set UPD_DT = to_date(sysdate-1,'DD-MON-RRRR HH24:MI:SS');
COMMIT;
END;

My python code im using it is as below:

import cx_Oracle
import json
import execsql.py

with open('InputData.json') as f:
    global data
    data = json.load(f)

f = open("testdata.sql")
full_sql = f.read()
sql_commands = full_sql.split(';')
conn = cx_Oracle.connect(data["usrid"],data["pwd"],data["conn"])
curs = conn.cursor()
print("Connection Sucess")
curs.execute(full_sql)

Error:
Error on running python code is as below:
  File "tstsqlfile.py", line 24, in <module>
    curs.execute(full_sql)
DatabaseError: ORA-00933: SQL command not properly ended