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...
AlexKaras's avatar
AlexKaras
Community Hero
13 years ago
Hi Tony,



Sorry for not replying earlier... but this is the expected behaviour. The case is that the native ADO (and thus the ADO wrapper object in TestComplete) does not support batch SQL statements. ADO requires such statements to be executed line-by-line, exactly like you've found out.