ORACLE (Build) Query problem


Author
Message
Ertan Deniz
Ertan Deniz
StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 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.

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