ORACLE (Build) Query problem


Author
Message
Ertan Deniz
Ertan Deniz
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 163, Visits: 493
I've executed object.FillByPrimaryKey on ORACLE database. (

I've got the query by setting debug-on feature.

The query :

SELECT "id", "group_id", "base_message_id", "type", "state", "inserted_user_id", "insert_date" FROM "dbo"."sn_srv_messages" WHERE id IN (TongueARAM0)  

After the query was executed, "ORA-00942: table or view does not exist." Error.

After I 've cleared the "" characters and run the query on a DB tool like SQLNavigator, the Query was succesfully executed.

Why does strataframe fail to run the query ? Why are "" characters generated by the framework ? 

Note : I've run the same query with object.FillDataTable. The operation is also successful.

Reply
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (938 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
The configuration for Oracle is to use quotes as the delimiters for quoted identifiers. Did you run the query with or without quotes when you used FillDataTable?

Regardless, quotes are the rule for Oracle, so it sounds as though the issue lies elsewhere.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search