today, I spent 3 hours working on a pl/sql package. A package that should have worked but it didn't. 3 hours of my life. 3 hours of my prime. 3 hours that I could have spent getting jiggy with some ilicit temptress but instead willingly wasted it in the company of a middle aged man, in the attempts of getting some godforsaken package to work. . . . . .In order that you may save a few hours of you life I will impart the solution to my woes:
Oracle 8i pl/sql cursors don't like too many sub-selects and aggregations in one fetch. If you do have too many, it will mysteriously replace recordset field values with each other so that the value of field 5 will equal field 1. No compilation issues. No error message. Just bad data.
Subscribe to:
Post Comments (Atom)
1 comment:
thanks a lot for your comment and for my English.I am flattered))))
when I have time, I'll read youк notes by all means!!best wishes, Russian girl))
Post a Comment