Dapper-Extensions icon indicating copy to clipboard operation
Dapper-Extensions copied to clipboard

Invalid table name(Oracle)

Open GitBySzl opened this issue 3 years ago • 4 comments

Hello! This is the database table: image

This is a POCO: image

"Invalid table name" kept coming back when inserting.

Solution. Thank you!

GitBySzl avatar Jul 27 '22 10:07 GitBySzl

Is this the only table with this issue???

valfrid-ly avatar Jul 28 '22 22:07 valfrid-ly

@GitBySzl hello! I think that isn't possible. You are using Automap for TLSLT0X class in another class. image

elvisveiga avatar Aug 27 '22 23:08 elvisveiga

I am also receiving the error as "Table or view doesn't exist". For Oracle. Probably, a good detailed documentation about how to use DapperExtensions for Oracle (or any db) would help beginners to implement - would be helpful. I am having doubt as to how the schema name will be set or read.

aravindk777 avatar Jan 04 '23 07:01 aravindk777

@aravindk777, tables are declared "SCHEMA_NAME"."TABLE_NAME".

Lets remember that Oracle IS case sensitive. If you declare a table name "test" and another one as TEST they will be different.

Usually people forget that as they don't use "" in the names, but with "" you can even use spaces in the names.

Did you check if it's not a case issue???

valfrid-ly avatar Jan 04 '23 15:01 valfrid-ly