Home » Developer & Programmer » Forms » FRM-40108-no such form (Forms 6i)
FRM-40108-no such form [message #308091] Fri, 21 March 2008 02:13 Go to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hello ,
I created a login form and a employee form.When I run these two forms separately,it works.
In the when-button-pressed trigger of the login button in the login form the code is :
NEW_FORM('EMP');

When it comes to this, it says FRM-40108No such form(emp).
Please tell me why and kindly solve this problem.
1.There are no compilation errors.
2.Both the forms are in the same folder.
3.both the forms run well separately.
Re: FRM-40108-no such form [message #308197 is a reply to message #308091] Fri, 21 March 2008 20:25 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi,
Quote:
When it comes to this, it says FRM-40108No such form(emp).
Please tell me why and kindly solve this problem.
1.There are no compilation errors.
2.Both the forms are in the same folder.
3.both the forms run well separately.

My dear , sure you have an error
./fa/4042/0/
  • Attachment: FRM-40108.JPG
    (Size: 17.45KB, Downloaded 3021 times)
Re: FRM-40108-no such form [message #308321 is a reply to message #308197] Mon, 24 March 2008 01:03 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hello,
Thanks for taking time to answer the question.
I know that , that is the explanation for the error FRM-40108.
But As I said, I ahve given the correct form name only.
and that the called forms runs well seaprately.
Only when it is called ,it says "no such form".
I code I had added was
NEW_FORM('EMP');

Also in another form, I try to calla form called appraisal.fmb
There the code is CAll_FORM('Appraisal');

Now someone please Help .. Sad
Re: FRM-40108-no such form [message #308919 is a reply to message #308321] Tue, 25 March 2008 23:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you defined your 'forms60_path'?

David
Re: FRM-40108-no such form [message #308950 is a reply to message #308919] Wed, 26 March 2008 01:03 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi David,
Can you tell me where I can find this FORMS60_PATH.
As I have searched through the whole of my C drive where my oracle_home resides
Should i check in registy .
In that case please tell me where is this FORM60_PATH ?
Re: FRM-40108-no such form [message #308957 is a reply to message #308950] Wed, 26 March 2008 01:23 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In registry, check HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE - HOME0. Or, set environment variable FORMS60_PATH.
Re: FRM-40108-no such form [message #309000 is a reply to message #308957] Wed, 26 March 2008 03:49 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hello ,
I could find forms60_path in registry,
It shows:
Value name : Forms60_path
Value data: C:\oracle\oracledev\TOOLS\OPEN60\PLSQLLIB

but I do not know what to do next.Please advise.

When I go to the path given there ,I see two .pll files and theire .plx files .
do you mean to say that I should place all my forms here?
If yes, then till now I have not palced any of my forms here and each of it rusn well.
Only problem is when a call a form,It says ,
FRM-40108 :no such form (or)
FRM:40010 Canot read form

[Updated on: Wed, 26 March 2008 03:53]

Report message to a moderator

Re: FRM-40108-no such form [message #309008 is a reply to message #309000] Wed, 26 March 2008 03:59 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Value data: C:\oracle\oracledev\TOOLS\OPEN60\PLSQLLIB

Add directory which contains your forms; new value might be, for example

Value data: C:\oracle\oracledev\TOOLS\OPEN60\PLSQLLIB;c:\my_forms
Re: FRM-40108-no such form [message #309025 is a reply to message #309008] Wed, 26 March 2008 04:36 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi LittleFoot,
I actually placed all my forms,lib etc in the path given intially .
Lo! it all works now.
However I am not able to add a new path in registry since I do not have admin privelges in my PC Sad .
Nevertheless I can see it all working now.
Thank you all for your responses!!
Re: FRM-40108-no such form [message #309064 is a reply to message #309008] Wed, 26 March 2008 06:19 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I prefer having my code out of ORACLE_HOME directories. I believe that you might create your own directory (such as c:\my_forms) and ask the administrator to add it into the registry. That's what these people are here for - do system maintenance tasks that ordinary users can't.
Re: FRM-40108-no such form [message #309080 is a reply to message #309064] Wed, 26 March 2008 06:48 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hello Littlefoot,
I have asked the sys admin to add teh path and now I ahve kept all my forms out of ORACLE_HOME.

Now Also it works fine .. Thank You !!
Re: FRM-40108-no such form [message #312226 is a reply to message #309080] Tue, 08 April 2008 04:33 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hello,
I un-installed my forms 6i, re formated my PC so that everything (the pc ) is new.
Then freshly installed oracle 9i Database and Oracle 10g DS.
However now when I call my form, I get "FRM-40010 , can not read form " error Sad
I have also added this location in my forms90_path ,still it does not work.
These forms were working fine on Forms6i.
Even now individually when run , they work, only when I need to call one form from another, the chain does not work Sad .
Please help.
Re: FRM-40108-no such form [message #312231 is a reply to message #312226] Tue, 08 April 2008 04:45 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Double check directory names; did you change its/their name(s) after reformatting your PC, so the "old" change to the FORMS90_PATH isn't valid any more?
Re: FRM-40108-no such form [message #312236 is a reply to message #312231] Tue, 08 April 2008 04:56 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi,
I have re-checked.Its the same.
Also there are two keys in registry , FORMS90 and FORMS90_PATH.
I have added this location in FORMS90_PATH alone.
I hope that is correct.
The value in registry for FORMS90_PATH is as follows :
C:\oracle\ora93\cgenf61\admin;C:\oracle\ora93\forms90;C:\forms
There are 3 locations and the type is REG_SZ.
the last one "C:\forms" is what I had added .
Where is the problem?
Re: FRM-40108-no such form [message #312251 is a reply to message #312236] Tue, 08 April 2008 05:12 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, right ... but now we are talking about a different error message (previous one was FRM-40108, this one is FRM-40010). Didn't notice it, sorry.

This is what Oracle says:
Quote:
FRM-40010: Cannot read form %s.

Cause:  One of the following:
1. You entered a nonexistent form name.
2. You typed an incomplete path.
3. You do not have the proper privileges to run the form.
4. You do not have a compiled copy of the form.

Action:  Retype the form name correctly, provide the proper path name, compile the form, or contact the DBA.
Re: FRM-40108-no such form [message #312258 is a reply to message #312251] Tue, 08 April 2008 05:27 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi,
It is an existing form.
The code was call_form('<form_name>');I do not think we need to give the complete path in Oracle 10g DS.
I have proper priveleges .There are forms I create for my learninig and they run well separately.
Has a complied version too.(It runs well individually, fails only when called from other form).
so now where is the mistake?

Is it because the key forms90_path can take only 2 values and what does type REG_SZ mean?
If that is the problem how can we change type or fix that ?

Re: FRM-40108-no such form [message #312429 is a reply to message #312258] Tue, 08 April 2008 19:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is either of the first two directories in the path empty?

David
Re: FRM-40108-no such form [message #312468 is a reply to message #312429] Wed, 09 April 2008 00:16 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
No, both have a few forms in them.
Re: FRM-40108-no such form [message #312487 is a reply to message #312468] Wed, 09 April 2008 00:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You say you are running Forms 10g. Then you should use 'FORMS_PATH' not 'FORSM90_PATH'.

David
Re: FRM-40108-no such form [message #312550 is a reply to message #312487] Wed, 09 April 2008 04:10 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi,
However my when I go to regedit, I find only forms90_path.and other keys are also form90_output, form90_..etc
the path I used is :
HKEY_LOCAL_MACHINE-->SAFTWARE-->Oracle-->HOME1


I think it is Froms10g as when I run the forms, the first message is "Oracle Applciation Server
Forms Services 10g "

So, what is it , 10g or 9i.now even I am confused Sad
Re: FRM-40108-no such form [message #312821 is a reply to message #312550] Wed, 09 April 2008 19:51 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
When you start Forms Builder does it say "Oracle Forms Developer, Oracle Developer Suite 10g"? When it has started, in the top menu go to 'Help > About Form Builder ...'. If it is Forms 10g you should have on the top line of the list "Forms [32 Bit] Version 10.1.2.0.2 (Production)"

David
Re: FRM-40108-no such form [message #312907 is a reply to message #312821] Thu, 10 April 2008 01:44 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi ,
Yes,
When I start Forms Builder it says "Oracle Forms Developer, Oracle Developer Suite 10g"
However in 'Help > About Form Builder: I see the following :

Forms [32 Bit] Version 9.0.4.0.19 (Production)
Oracle Toolkit Version 9.0.4.0.31 (Production)
PL/SQL Version 9.0.1.5.1 (Production)

So what is this? 10 g or 9i ??
Re: FRM-40108-no such form [message #312915 is a reply to message #312907] Thu, 10 April 2008 02:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I think it is the earliest version of 10g, which happens to be a 'rebadged' 9i.

Try using 'forms_path' and see what happens. I will re-review the whole of this thread when you get back with your response to this change.

Have you considered installing the latest version for Forms 10g or do you have to keep in 'synch' with your other work-stations.?

David
Re: FRM-40108-no such form [message #312936 is a reply to message #312915] Thu, 10 April 2008 03:03 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
As I told earlier there is no forms_path in registry,Only forms90_path..
DO you want me to create a forms_path key in the registry ?
Will having the earliest version of Oracle 10g actually mean that the features in 10g are supported or is it more lop-sided to 9i and might not support features of 10g?
Re: FRM-40108-no such form [message #313177 is a reply to message #312936] Fri, 11 April 2008 00:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
radhika,

My apologies for taking so long to solve this problem for you. Okay, you have your 'forms90_path' defined with your working directory at the end of the list. What I forgot to say was to make sure that your Forms Builder has that directory as the 'Start in' parameter of its short-cut.

Also make sure that you don't have any 'forms_path' specified in your 'default.env' file.

David
Re: FRM-40108-no such form [message #313210 is a reply to message #313177] Fri, 11 April 2008 01:30 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
David
... make sure that your Forms Builder has that directory as the 'Start in' parameter of its short-cut.

Hm, my "Start in" is EMPTY (and no problem so far ("so far" lasts for couple of years, I believe)) so - perhaps it isn't the key?
Re: FRM-40108-no such form [message #313212 is a reply to message #313177] Fri, 11 April 2008 01:37 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi,
Your idea worked only when I pasted the forms in the default path given in forms90_path which is $Oracle_home/forms90
and gave that location in the shortcut Start -in properties.
When I placed them in my working directory C:\forms and changed my start-in value,
It stopped working.
Though I did all what you had said.
Now I feel like crying Sad Sad
I just do not understand what more oracle Forms needs ?

forms_path is not there in the default.env file,only forms90_path is there.I even added my directory location in form90_path in default.env too.
Still not working Sad
Re: FRM-40108-no such form [message #313217 is a reply to message #313212] Fri, 11 April 2008 01:54 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi ,
Now it works.
I closed my forms builder.
deleted the old .fmx
Opened forms builder
I just recomplied my forms.
Now it works..
Thanks a bunch for helping me out.. Smile
I think adding the location in default.env in forms90_path has helped..
Re: FRM-40108-no such form [message #313583 is a reply to message #313217] Sun, 13 April 2008 19:17 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes, you have to stop and restart the Forms Builder after changing the 'Start in'. Please try one more time the configuration where your 'C:\forms' is in the 'Start in' and the 'forms90_path' (you ARE running 10g R1 so think 9i to-the-max, not 'real' 10g). Remove your change from 'default.env'. Stop your Developer Server and Forms Builder, then restart them both. Make sure that your call to the second form is by form name alone (that is, no extension and no directory leader/prefix).

Best of luck.

David
Previous Topic: FRM-40743
Next Topic: Need to click buttons twice for them to work
Goto Forum:
  


Current Time: Thu Dec 08 08:32:56 CST 2016

Total time taken to generate the page: 0.13220 seconds