Oracle Forms 6i
Thanks! We'll email you
when relevant content is
added and updated.
I am using a multi - DB block in my forms 6i and everytime I run a execute_query statement, it does not returns all the rows, rather I am getting ORA-01002: fetch out of sequence error.
I tried looking in the web and most of the places they said not to write COMMIT if using FOR UPDATE.but I haven't written a For Update or Commit anywhere.
My code is very simple
|set_block_property('FOURNITURES',default_where,'metier=:global.metier and sitegeo=:global.sitegeo and cptdossier=:global.zonecptdossier and numligne=:Global.zonenumligne');|
It should return 7 rows, but only returns 5 and when I press shift + F1 it shows this error ORA-01002: fetch out of sequence. (also the query is correct and returns 7 rows when I run it from Toad)
I will be really glad if someone can provide some help on this.