Re: How reliable is a cursor in Forms ?

... ok, ok, I should have read the entire PU to the end, which is a little longer ...

It was an "exit when C_AnotherCursorInTheLoop%NOTFOUND that ended the loop before time ...
Everything is alright, and I am going to have a nice evening now ...

Jan=)

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> schrieb im Newsbeitrag news:amcqsp$4b38f$1_at_ID-152732.news.dfncis.de...
> How reliable is a cursor ?
>
> 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,
> 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.
> 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 - 18:32:50 CEST