Solved

Web Forms gives FRM-99999 on inserts

Posted on 1998-10-14
2
486 Views
Last Modified: 2008-03-06

Aaarrrgghhh!
Full points for a solution to this problem!

We're running Developer 2000 v1.6.1 over the web,
using Oracle's forms listener f45ctl and database 7.3.4.  
We get an FRM-99999 when inserting records
using a Web Form.
We have a forms procedure that loops on:
      insert into report( UUI, ID, UUVAL)
      values ( uui, NULL, :query.view_uui)

The first 5 records are inserted successfully;
then it dies with FRM-99999.
When we try this in Dev 2K without using the Web
interface, it works great for all 500 records.

The "Details" of the FRM-99999 error seem to vary:
sometimes "socket closed", sometimes "EOFException",
sometimes "null pointer exception".

Please help!
Full points for a solution to this problem!
0
Comment
Question by:ssullivan
  • 2
2 Comments
 

Accepted Solution

by:
westheid earned 200 total points
ID: 1082060
There exist a patch2 (in addition to patch1) for
Oracle-Developer-Server 1.6.1.
This patch will handle the FRM-99999 Errors.
Saw this with Oracle-Applications R11 OWAS 3.0.1.8 / ODS 1.6.1

0
 

Expert Comment

by:westheid
ID: 1082061
There exist a patch2 (in addition to patch1) for
Oracle-Developer-Server 1.6.1.
This patch will handle the FRM-99999 Errors.
Saw this with Oracle-Applications R11 OWAS 3.0.1.8 / ODS 1.6.1

Nevertheless there exists a Environment-Variable
FORMS45_TIMEOUT
Just set it to 1440 (seconds). This will help.


Bye
   Frank
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now