search

schotime / NPoco

Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
Apache License 2.0
848 stars 302 forks source link

ORA-00933: SQL command not properly ended #660

Closed ikvm closed 2 years ago

ikvm commented 2 years ago

oracle 19c and Oracle.ManagedDataAccess.Core 3.21.3, call InsertBatch throw exception "ORA-00933: SQL command not properly ended"

schotime commented 2 years ago

I don't use Oracle and you haven't really given and information about what the query looks like. Have you run the resulting query in Oracle etc?

ikvm commented 2 years ago

image

schotime commented 2 years ago

Is it because there is no ; at the very end?

ikvm commented 2 years ago

the ORACLE block statement is start with “BEGIN” and end with “END”

schotime commented 2 years ago

If you add another semi colon to the end of the statement in your image what happens?

ikvm commented 2 years ago

image

wasabii commented 2 years ago

@ikvm Do you have any contact information I can use to reach you by? I resorted to trying to ping you on this issue because I could not find any.