asked on

FRM-40734: Internal Error: PL/SQL error occurred Forms 11g

I have just started using Forms 11g after using 6i several years ago, so my memory is a bit foggy on where to find stuff. I'm not even sure what information you need in order to help me troubleshoot. I'm running on Windows 7 64-bit and the database is 11g.

I have two forms, both of which work in production, which makes me think the problem might be with my setup. One of the forms I can run locally without a problem, the other gives me this error message.

The main difference between the two forms is that the one that works uses text_io, the one that does not work uses client_text_io from the attached webutil library.

Can anyone tell me where to look for the root of this problem? I have looked through a bunch of folders under C:\Oracle\Middleware but cannot find any log files that seem to correlate with the problem I'm having.

Thank you!
Cali

Helena Marková

I would look at
1. ) default.env file if there is:
# webutil config file path
WEBUTIL_CONFIG=C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\server\webutil.cfg
...
CLASSPATH= .... C:\Oracle\Middleware\ORA_HOME\forms\java\frmwebutil.jar ...

2.) formsweb.cfg:
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=icons.jar,jacob.jar,frmall.jar,frmwebutil.jar -- order is important
...
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTML=webutilbase.htm
baseHTMLjpi=webutiljpi.htm
archive=frmall.jar
lookAndFeel=oracle

Also there must be webutil.plx and webutil.olb where your *.fmx are located.

I hope this can help you.

tancat

ASKER

default.env was correct, I fixed the order in formsweb.cfg, and changed my semi-colons to commas. webutil.plx is in my folder where my fmx is, but I could not find webutil.olb on our network; however, there is another olb file, ofgwebol.olb, that I put in the same folder as the fmx and plx.

I don't get as far now as I did before. As soon as the form opens, FRM-93652 pops up. Previously I was able to enter values and the file was created, just never written to.

I will ask about the webutil.olb file.

Thanks!
Cali

tancat

ASKER

Ok, we don't use the webutil.olb file, apparently, or no one knows about it and everything is theoretically working without it.

Since the suggested changes did not help the situation, I reversed them, and went back to an empty file being created and the FRM-40734 error. It appears that this line is not liked:

loc_test_file := CLIENT_TEXT_IO.FOPEN(P_PATH||loc_filename,'w');

I have displayed the path and loc_filename and both appear to be valid, and the file is created, but i can't get past this line.

Rumor has it that client_text_io doesn't work when you run forms locally, only text_io does. Would you know anything about that?

Also, my shop has sent out instructions to have us install everything for deployment instead of development...that doesn't seem necessary. Does anyone have an opinion about that?

Thanks!
Cali

ASKER CERTIFIED SOLUTION

Helena Marková

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tancat

ASKER

Thank you for the help. Eventually last night I found webutil.olb and found that it was attached to our forms (subclassed)...so now I suspect that I might not be the only one on the team who is out in left field. ;-)

I'll do some reading today and get back to you.

Thanks!
Cali

tancat

ASKER

Thank you! I never did figured out what was wrong with my installation, I uninstalled and reinstalled about a half dozen more times, and I still don't think it's correct. But you gave me a lot of information in your answer and pointed me in the direction that I needed to at least get it mostly "working".

Helena Marková

I am glad to help you :).