Re: Upgradding Problem From45 to Form50

tyou_at_adm.cgmh.com.tw wrote:
>
> 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 newsreadingForms 5 does like Global variables !
Received on Wed May 20 1998 - 21:27:21 CEST