Solved

Oracle Form 6i cannot recognize attached library

Posted on 2007-03-25
9
4,396 Views
Last Modified: 2013-12-19
I am using Oracle Forms 6i, the form comes with an attached library which was compiled OK. I tried to execute the form by running it directly (from Program > Run Form > Client / Server from form builder and it works as expected.

However, recently I encountered an error and would like to debug the form. The problem is, when I tried to debug the form from the Program > Run Form > Debug menu, the form couldn't seem to recognize my attached library. It works fine when I step to the form codes, but pop up error when the codes reached the attached library statement. The error code returned is: FRM-40735 : ON-ERROR trigger raised unhandled exception ORA-06508.

I've tried recompiling the server procedure, recompile the attached library, removing, reattaching the library but the outcome is the same. My form and the library sits in the same directory. This is how I opened my form builder.. It's a command file.

SET ORACLE_SID=MYTESTDB
SET NLS_LANG=AMERICAN_AMERICA.ZHT16MSWIN950
SET NLS_DATE_FORMAT=DD/MM/YYYY
SET FORMS60_PATH=C:\myForm\forms
SET UI_ICON=C:\myForm\forms\icon

cd C:\myForm\forms
C:\orant\BIN\ifbld60.EXE

Anyone come across this before? Please help... Thanks a lot...
0
Comment
Question by:huiyingloh
[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
  • 5
  • 4
9 Comments
 
LVL 12

Expert Comment

by:jwahl
ID: 18791127
did you remove the path when attaching the library to the form?
0
 

Author Comment

by:huiyingloh
ID: 18791132
yes.. I did remove the path when Forms asked the "....non portable directory specification..." question.

The .cmd file I used to open my form builder resides on my desktop.. I think it doesn't matter where I placed this, right? Coz for the previous project, this works alright..  

0
 
LVL 12

Expert Comment

by:jwahl
ID: 18791148
but check also if you have entered a working directory in the .cmd file on you desktop ...!
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:huiyingloh
ID: 18791155
Hi Jwahl,
This is how my command file looks like:

*******************************************************
SET ORACLE_SID=MYTESTDB
SET NLS_LANG=AMERICAN_AMERICA.ZHT16MSWIN950
SET NLS_DATE_FORMAT=DD/MM/YYYY
SET FORMS60_PATH=C:\myForm\forms
SET UI_ICON=C:\myForm\forms\icon

cd C:\myForm\forms
C:\orant\BIN\ifbld60.EXE
*******************************************************
my working directory is C:\myForm\forms
0
 
LVL 12

Expert Comment

by:jwahl
ID: 18791204
sorry for confusing you ... i meant if the desktop ICON is a shortcut to your *.cmd file, it may have itself a seperate working path.

if so, remove the path and try again.

0
 

Author Comment

by:huiyingloh
ID: 18791227
Hi Jwahl,

I found out the reason already... ! It's not due to the *.cmd file afterall..  After a few searches online, I found out that the reason for the error is because, when I compiled the .pll file, I need to click save to save the compiled .pll even though there's no changes... (duh!!) I didn't save the changes previously and assumed that the .plx generated should be ok for the Forms to use.. (if ever the form builder is going to use it.. )

Then, following one of the instructions on a website, I re-compiled the .pll again, saved it, remove library attachment, re-attached saved version of the pll, with no changes.. and viola! the debug works... :)

Should've tried one extra time before opening this Q... :S .. Thanks for your help anyways, Jwahl.
0
 
LVL 12

Accepted Solution

by:
jwahl earned 125 total points
ID: 18791260
yes, it's the behavior of the forms builder:

for compiling the *.pll file is used. but the runtime uses the *.plx and the *.pll only then if no *.plx is found ... and compiling a library IS changing it.



0
 

Author Comment

by:huiyingloh
ID: 18791297
Hi Jwahl,
Something to clarify... You mentioned that, the runtime will first use *.plx and if there's no *.plx file, it will use the *.pll file.

This means that even though if I dont save the *.pll file after compiling it, there should not be a problem, right? Because after my compilation, my directory now have a compiled OK version of *.plx file and an unsaved copy of *.pll. Knowing the behavior of runtime which will use the *.plx first, then it will not load the unsaved version of *.pll? Is my understanding wrong?
0
 
LVL 12

Expert Comment

by:jwahl
ID: 18791478
i think your assumptions are right.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Pivoting oracle table 9 74
Oracle Errors 11 51
Star schema daily updates 2 37
Oracle 11gR2 Middleware: multiple domains with individual admin servers? 4 23
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

749 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