when i perform a select on a given view i get: Devart.Data.Oracle.OracleException: ORA-01002: fetch out of sequence
This view is different from other ones in the sense that is a view base on a select where 3 remote tables over a database link are joined
Perfoming a select in sqlplus goes fine..maybe internally in oradirect it is performed in a pl/sql block?(read something obaut cursors causing problems) I also tried performing the select through a stored procedure(and map the result back to an entity but i get the same error)
Exception during view-read
The view causing the problem is a view over another view(that is a join of 2 remote tables) in a remote database through a database link.(distributed environment)
eg CREATE OR REPLACE VIEW X
AS SELECT * FROM VIEW@dblink;
If i use a view that is a selection of a remote table over a databaselink everything works fine:
eg:CREATE OR REPLACE VIEW X
AS SELECT * FROM TABLE@dblink;
Can you tell me if the oradirect tool creates a pl/sql block in which the data is retrieved? What i find on the oracle-forum is that execution of view-data using db-links with a cursor on it can cause problems. Is this possible due to how the tool works internally?
eg CREATE OR REPLACE VIEW X
AS SELECT * FROM VIEW@dblink;
If i use a view that is a selection of a remote table over a databaselink everything works fine:
eg:CREATE OR REPLACE VIEW X
AS SELECT * FROM TABLE@dblink;
Can you tell me if the oradirect tool creates a pl/sql block in which the data is retrieved? What i find on the oracle-forum is that execution of view-data using db-links with a cursor on it can cause problems. Is this possible due to how the tool works internally?