Forum Discussion

RKDY91_1's avatar
RKDY91_1
New Contributor
13 years ago

ORA-00911: invalid character when trying to execute an insert statement on an oracle db

I have a script which returns when running a select statement but when trying to do an insert i get an "ORA-00911: invalid character" error . when I try to execute the same on sql developer the...
RKDY91_1's avatar
RKDY91_1
New Contributor
13 years ago
I found the solution by trying various options.



here is the solution



execute the insert in parts



first execute the insert without semi colon 



then execute the commit statement



qry.execute(insert into mguser.psa (activity_date,activity_time)values('xyx','xyx'))



qry.execute("commit")



this is strange but does the work for me.



Thanks,

Tony