python - Why is semicolon an invalid character in cx_Oracle? -


i'm relatively new databases, can explain me why case?

e.g. following gives invalid character error:

dsn_tns = cx_oracle.makedsn(ip, port, sid)  # cx_oracle.connect([user, password, dsn, mode, handle, pool, threaded, events, cclass, #   purity, newpassword, encoding, nencoding, edition, appcontext, tag, matchanytag]) conn = cx_oracle.connect(user = username, password = password, dsn = dsn_tns)  cur = conn.cursor() cur.execute("select * mytable;") 

the execute() method takes single sql command, , semicolon never part of command. used separate multiple commands executed in sequence.


Comments