Home » Developer & Programmer » Forms » FRM-92101 Error (Oracle Forms)
FRM-92101 Error [message #389131] Fri, 27 February 2009 06:20 Go to next message
ksgsharma
Messages: 10
Registered: February 2009
Location: LR, Arkansas, US
Junior Member
Hi,

In the Data Block Wizard --> INSERT Tab I have given the Insert SP Name. On Compilation the Forms Builder automatically created the INSERT-PROCEDURE Trigger which contains the following code:

DECLARE
bk_data SPKG_ORACLE_FORMS.EMP_TABLE_TYP;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'EMP_DET', PLSQL_TABLE.INSERT_RECORDS);
SPKG_ORACLE_FORMS.SP_INSERT_EMP_DET(bk_data);
END;


I have copied this code and pasted it in a Add Button Trigger(WHEN-MOUSE-CLICKED) and tried to insert a new record by pressing this ADD Button, but then the followign error is coming:

FRM-92101:There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details.

and the form is getting closed.

Please Help ...
Re: FRM-92101 Error [message #389247 is a reply to message #389131] Fri, 27 February 2009 15:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to "Compile All" the form? (Ctrl + Shift + K)
Re: FRM-92101 Error [message #389267 is a reply to message #389131] Fri, 27 February 2009 22:35 Go to previous messageGo to next message
ksgsharma
Messages: 10
Registered: February 2009
Location: LR, Arkansas, US
Junior Member
Thanks .. mate .. even after Compiling All (Ctrl + Shift + K), same exception (FRM-92101) persists.

It says there might be a problem in configuration. But if that is the case then form should not open in the first place.

I m totally confused. Please help ...
Re: FRM-92101 Error [message #389894 is a reply to message #389267] Wed, 04 March 2009 00:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
From where did you get the Form?

David
Re: FRM-92101 Error [message #391222 is a reply to message #389131] Wed, 11 March 2009 08:33 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
hi im my form i am also getting
-- Automatically generated trigger for procedure data source.
-- Do not edit.
-- If this trigger fails to compile, verify the block procedure data source is correct.
DECLARE
bk_data ASSIGNREPORT.TBREPORTTDLTAB;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'CYCLE_COUNT_TASK_DETAIL', PLSQL_TABLE.INSERT_RECORDS);
ASSIGNREPORT.REPORTTDLCREATE(bk_data);
END;

these triggers

so i want to know where we can see the 'CYCLE_COUNT_TASK_DETAIL'
is it any tabel or what as it is not in database. and i am new to forms...

so pelase reply
Re: FRM-92101 Error [message #394698 is a reply to message #391222] Sun, 29 March 2009 19:13 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you are new to Forms then you don't need to see or search for this information. If you have a problem in your form then considering in making a change to these triggers is not the way to go. I also strongly recommend NOT copying generated code to other triggers. If you need to force similar logic then in the new trigger execute the generated code by invoking that trigger in your code.

I believe that your logic may be too complex. Please reconsider your logic.

David
Previous Topic: Tutorial site link of Oracle Developer 10g
Next Topic: help me please
Goto Forum:
  


Current Time: Sat Dec 10 16:36:33 CST 2016

Total time taken to generate the page: 0.07382 seconds