Upgradding Problem From45 to Form50

From: <tyou_at_adm.cgmh.com.tw>
Date: Wed, 20 May 1998 09:30:30 GMT
Message-ID: <6ju7rm$q9v$1_at_nnrp1.dejanews.com>

[Quoted] Hi , dear Oracle Gurus:

   Now, I had a problem with upgrading my forms from Dev2k/Forms4.5 to Dev2k/Forms5.0 .

   When I open the form which designed by Form 4.5 using From 5.0 form buildder,the buildder converts my form automatically.

   After all,I compile the form again.It shows what error in my procedure.

 1--  PROCEDURE p_gen_sql IS
 2--     out_file 	text_io.file_type;
 3--     N	        NUMBER(1);
 4--  BEGIN
 5--  p_path;
 6--  out_file := TEXT_IO.FOPEN(:b0.path||LOWER(:global.tab)||'.sql','w');
 7--
 8--  IF :BY.COMMENT='Y' THEN
 9--     N:=6;
10-- ELSE
11--    N:=5;
12-- END IF;
13--
14-- for x in  1..N loop
15--    go_record('1');
16--    while :b1.i is not null loop
17--      if :b1.i=x then
18--         TEXT_IO.PUT_LINE(out_file,:b1.d);
19--         delete_record;
20--      else
30--         down;
31--      end if;
32--    end loop;
33-- end loop;
34-- TEXT_IO.FCLOSE(OUT_FILE);
35-- :B0.ALL_NAME:=:B0.ALL_NAME||:global.tab||',';
36--
37-- EXCEPTION WHEN OTHERS THEN
38--     if TEXT_IO.IS_OPEN(out_file) then
39--       TEXT_IO.FCLOSE(OUT_FILE);
40--    END IF;
41--    raise form_trigger_failure;
42-- END;

case 1:

Then I go to the procedure and I got the error message :

" Error 801 at line 1,column 1

        internal error [76120] "

I don't know what's happen. The line 1 is simple define the procedure. I tried to mark the lines in the procedure ,and I got that the procedure would compiled well if I marked the line 35 as comment .

     :B0.ALL_NAME:=:B0.ALL_NAME||:global.tab||',';

  B0.ALL_NAME --- a text item with LONG datatype and max length 9000000.

But it is important to my form. I can't delete it from my form.

case 2.
Again , I removed the mark from the line 35 and I got error message above . After I compiled it more than two times,I would get the system error like the following:

F50DES32 caused a divide error in module PLS234.DLL at 0137:0081def4. Registers:

EAX=ffffffff CS=0137 EIP=0081def4 EFLGS=00010296
EBX=00000000 SS=013f ESP=00afcd7c EBP=00afd620
ECX=0237336c DS=013f ESI=00000003 FS=3707
EDX=00000000 ES=013f EDI=00afd6d0 GS=0000

Bytes at CS:EIP:
f7 75 e0 40 6a 00 51 8b 55 08 52 89 45 e8 e8 29 Stack dump:
00000000 00000000 00000004 00afd6d0 00b33594 00000000 00000000 00b1360c 00000000 00b45ba8 00b2be78 01f10780 01f10790 01f10770 00000000 00000000

And the OS terminated Form buildder!!!!
I am so helpless!!
Any suggestions are welcome!

Yous,

    Tom You

 e-mail: tyou_at_adm.cgmh.com.tw

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 20 1998 - 11:30:30 CEST