| FRM-92101 Error [message #389131] |
Fri, 27 February 2009 06:20  |
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 #389267 is a reply to message #389131] |
Fri, 27 February 2009 22:35  |
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 #391222 is a reply to message #389131] |
Wed, 11 March 2009 08:33 |
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 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
