Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Web Forms gives FRM-99999 on inserts

Posted on 1998-10-14
2
Medium Priority
?
494 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
westheid earned 800 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

618 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