Home » Developer & Programmer » Forms » ORA-06508 in every form 11g
ORA-06508 in every form 11g [message #488188] Wed, 05 January 2011 10:15 Go to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
Hello to all,

I'm migrating my forms 6i to 11g. My problem is that every single form has an error when loading. The error is "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508." In the beginning there were more errors and by converting all forms and libraries and then compiling them, i was able to clear all the errors. But this one isn't going away. I compile the forms and everyting is fine. So could it really be some program unit that is missing? Just to tell, with a form created is forms 11g the error don't show up. What can it be?
Re: ORA-06508 in every form 11g [message #488247 is a reply to message #488188] Wed, 05 January 2011 13:02 Go to previous messageGo to next message
joy_division
Messages: 4504
Registered: February 2005
Location: East Coast USA
Senior Member
Is there an attached library that is missing or not attached when you converted them?
Compile them in Forms Developer and it should tell you what is missing.
Try running it in Forms Developer instead of the App Server.

Oh, and what is the code in ON-ERROR trigger? Didn't you look there first?

[Updated on: Wed, 05 January 2011 13:03]

Report message to a moderator

Re: ORA-06508 in every form 11g [message #488302 is a reply to message #488188] Thu, 06 January 2011 04:54 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
All pll's are atached correctly. I compile in Forms builder and it's successful. Only in runtime it displays the error. After bumping my head to the wall, i discover that if i remove the trigger WHEN-NEW-FORM-INSTANCE he loads correctly but the same error displays whenever i do something else. Could it be that all triggers are shooting this error? Maybe i could try to copy an entire form to a new one created firsthand in 11g and see if it still gives the error no?

Information: I have my forms 6i all built in windows, and i am now builting my 11g in linux. To convert them i use frmplsqlconv and then frmcmp to compile them.
Re: ORA-06508 in every form 11g [message #488308 is a reply to message #488302] Thu, 06 January 2011 05:29 Go to previous messageGo to next message
cookiemonster
Messages: 10930
Registered: September 2008
Location: Rainy Manchester
Senior Member
When you attach the plls are you telling it to save the path or not?
Where have you put the plls on the linux server?
Re: ORA-06508 in every form 11g [message #488312 is a reply to message #488308] Thu, 06 January 2011 05:36 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
I tell YES to remove path.
I put them in the same directory of forms (/oracle/product/Middleware/oracle_fr/forms), but i noticed that if i remove them from there it is the same thing. All forms are loaded, all errors remains the same.
Re: ORA-06508 in every form 11g [message #488340 is a reply to message #488312] Thu, 06 January 2011 09:23 Go to previous messageGo to next message
SAMAHAI
Messages: 7
Registered: December 2010
Location: United States
Junior Member
Refer the below link for errors and solutions.

http://www.errorpro.com/oracleerrors/
Re: ORA-06508 in every form 11g [message #488342 is a reply to message #488340] Thu, 06 January 2011 09:26 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
If i wanted generic help i would only bother google. I need specialized help.

But i already use that site, because it's a good one.
Re: ORA-06508 in every form 11g [message #488345 is a reply to message #488342] Thu, 06 January 2011 09:35 Go to previous messageGo to next message
cookiemonster
Messages: 10930
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's the actual code in the on-error trigger?
Re: ORA-06508 in every form 11g [message #488347 is a reply to message #488345] Thu, 06 January 2011 09:49 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
I'll post here the complete code of the ON-ERROR trigger:

DECLARE 
  dbmserrcode NUMBER; 
  dbmserrtext VARCHAR2(200); 
BEGIN 
   IF ERROR_CODE = 40401 THEN
      /* Botao confirmar premido com ecran vazio */
      sdf_informa ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' N?o ha nada para gravar!' );
	RAISE form_trigger_failure;

   ELSIF  ERROR_CODE = 41000 THEN
      /* Func?o n?o disponivel */
      sdf_informa ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' Tecla desactivada!' );
	RAISE form_trigger_failure;

   ELSIF  ERROR_CODE = 40100 THEN
      /* Usado o << no primeiro registo */
      sdf_informa ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' N?o ha registos anteriores!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 40209 THEN
      /* A mascara n?o esta a ser respeitada */
      sdf_stop ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' Caracteres invalidos no campo.'||CHR(13)||
		'Formato incorrecto!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 40212 THEN
      /* Valor invalido no campo */
      sdf_stop ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' Valor invalido para este campo!');
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 41051 THEN
      /* N?o pode criar records neste campo */
      sdf_aviso ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' N?o pode inserir linhas neste ecr?!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 41830 THEN
      /* List of values contains no entries.*/
	sdf_aviso( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
	      ' N?o existe qualquer valor para escolher.');
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 50016 THEN
      /* caracteres invalidos no campo */
      sdf_stop ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' Caracteres invalidos no campo!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 40202 THEN
      /* campo obrigatorio nao preenchido */
      sdf_stop ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' O campo deve ser preenchido!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 41004 THEN
      /* buttao << em QUERY-MODE */
      sdf_aviso ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' Este but?o n?o pode ser usado aqui!' );
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 40508 THEN
      /* registo nao inserido na base de dados */
      sdf_stop ( ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		' O registo n?o foi inserido na base de dados.'||CHR(13)||
		'Verifique se ja existe!');
	RAISE form_trigger_failure;

   ELSIF ERROR_CODE = 40735 THEN 
          /* Excepc?o n?o tratada */ 
      dbmserrcode := DBMS_ERROR_CODE; 
      dbmserrtext := DBMS_ERROR_TEXT; 
      IF dbmserrcode = -1400 THEN 
            /* ORA-01400 is "Mandatory column is NULL" */ 
          sdf_stop(to_char(dbmserrcode)||': '||
		' N?o preencheu um valor obrigatorio!'); 
      ELSIF  dbmserrcode = -02291 THEN
	    /* ORA-02291 is "Parent key not found" */
	  sdf_stop(to_char(dbmserrcode)||': '||
		' Este valor n?o e valido na Base de Dados!');
      ELSE 
            /* Escreve uma mensagem generica com a string de erro. */
          sdf_stop('Erro: '||ERROR_TYPE||'-'||to_char(ERROR_CODE)||':'||
		to_char(dbmserrcode)||': '||dbmserrtext);
	  RAISE form_trigger_failure;
      END IF; 

   ELSE 
       sdf_stop(ERROR_TYPE||'-'||TO_CHAR(ERROR_CODE)||': '||ERROR_TEXT);
       RAISE Form_trigger_failure;
   END IF;
END;  
Re: ORA-06508 in every form 11g [message #488348 is a reply to message #488347] Thu, 06 January 2011 10:01 Go to previous messageGo to next message
cookiemonster
Messages: 10930
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's sdf_stop exactly?
Re: ORA-06508 in every form 11g [message #488349 is a reply to message #488347] Thu, 06 January 2011 10:03 Go to previous messageGo to next message
Littlefoot
Messages: 19541
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SDF_something might be a culprit. What are those SDF_ procedures? Where are they?
Re: ORA-06508 in every form 11g [message #488350 is a reply to message #488349] Thu, 06 January 2011 10:07 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
sdf_stop is just to display message. All those sdf_something are in my pll. And it is added correctly.

Note: i've now done what i said before. I basically copied my form content to a new form created from scratch in 11g. It doesn't work all fine but this errors are no longer there. What do you think? Could it be the frmplsqlconv that is converting badly?
Re: ORA-06508 in every form 11g [message #488364 is a reply to message #488350] Thu, 06 January 2011 12:06 Go to previous messageGo to next message
Littlefoot
Messages: 19541
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you open the form in Forms Developer and compile "all" (Ctrl + Shift + K) before generating the FMX? Any improvement?
Re: ORA-06508 in every form 11g [message #488365 is a reply to message #488364] Thu, 06 January 2011 12:10 Go to previous messageGo to next message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
Compiled Successfully. That's what happens.

I also tried now to test a form without converting to 11g. Meaning i comment all the code that display an error and compile it, but it's the same. Besides frmplsqlconv, are there anyother way to convert forms?
Re: ORA-06508 in every form 11g [message #488468 is a reply to message #488365] Fri, 07 January 2011 09:54 Go to previous message
hidetsugu
Messages: 20
Registered: January 2011
Location: Portugal
Junior Member
I was able to avoid this error by not using frmplsqlconv. I only open my 6i form in 11g builder and change somethings to use two new libraries and compile. And now i don't experience errors. Thanks for all the help
Previous Topic: ORA - 12537: TNS connection closed
Next Topic: accentuation
Goto Forum:
  


Current Time: Wed Sep 03 01:04:54 CDT 2014

Total time taken to generate the page: 0.06907 seconds