How reliable is a cursor in Forms ?

[Quoted] I had a very strange result: testing the cursor in SQLPlus as

• Cursor C_Person Is Select Id From Person --**************************************** Where instr(name, chr(10) ) > 0; --****************************************

A test record in table person with id = 456633 _had_ a chr(10) in its name, [Quoted] and the select finds it without any problem.

But when I do the following in a Form, it is _not_ found.

      ...
         Open  C_Person;
         Text_Io.Put_Line (v_File, v_Header);

         Loop


            --1. find special persons with carriage retruns in their names.


[Quoted]             Fetch C_Person
               Into
               v_Pers_Id;

            if v_pers_id = 456633 then
               insert into error_erg (s1) values ('I found the test
record');
               commit;
            end if;

            Exit When C_Person%NotFound;



            --2. ...do much more and make output file.


            ..........
         End Loop;
         Close C_Person;
         ...

When I run the Form to the end and test error_erg for 'I found ...', I see that the test record has not been selected - although it should have been.
And the output file prooves it ...

What the hell is going on here, I really feel like a bloody beginner again ...

I would appreciate any comments.

ThanX in advance, Jan

(Oracle EE 8.1.6 on AIX 4.3.3, working an a Windows Client with Oracle Forms) Received on Thu Sep 19 2002 - 17:32:31 CEST