Commandbuilder exception
535955Sep 26 2006 — edited Sep 27 2006I am using OracleCommandBuilder to build select/insert/update/delete for the data adapter. This works fine with the 9.2.0.4 provider. But when I try on the 10.2.0.1 (or 10.2.0.2.20). I always get the "Dynamic SQL generation failed. No key information found" exception. (.Net v1.1)
I have done an “alter session set current_scheme=<different schema>” before in the session to avoid the prefix of the schema owner (or views, or public synonyms…). If I connect using the schema owner to connect, this problem disappears. Any suggestions? Anyone know if this is a known bug in the provider?
I guess the CommandBuilder do some selects on the system tables to get the primary key. And put user instead of schemaname (like schemaname in the v$session view) in the where condition.