Home » Developer & Programmer » Forms » Master Detail Form Error (Forms 6i)
Master Detail Form Error [message #420362] Fri, 28 August 2009 09:46 Go to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

Hi,
I have created a master-detail Forms for Department(Master) and Employee(Detail) howebver when i run the form and search for a record i get the error FRM 40735 ON CLEAR DETAILS raised an Error ORA-06508.
Not able to figure out why.
Any help would be greatly appreciated.

Thanks,
Aabhas
Re: Master Detail Form Error [message #420385 is a reply to message #420362] Fri, 28 August 2009 16:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Because you are calling a program unit which is not accessible (or does not exist).
Oracle
ORA-06508 PL/SQL: could not find program unit being called

Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.

Re: Master Detail Form Error [message #420512 is a reply to message #420385] Mon, 31 August 2009 01:12 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

Well Littlefoot.. I knw what the error code means.. Even I googled for it.
But i am, taking care for all the program units being called.
Still getting this error.
Has anyone evenr faced this kind of error in a master detail form creation.
Please help?
Re: Master Detail Form Error [message #420545 is a reply to message #420512] Mon, 31 August 2009 04:46 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you share the code you have used in this program unit, so that we could see it?

Did you grant all required privileges? Note that privileges granted via roles will not work in PL/SQL (which Forms triggers are) - you'll have to grant these privileges directly to the user.
Re: Master Detail Form Error [message #420637 is a reply to message #420545] Tue, 01 September 2009 03:06 Go to previous messageGo to next message
alimahboob
Messages: 14
Registered: November 2005
Location: jeddah
Junior Member

pls check the attached form and test it against dept, emp tables in scott schema.
  • Attachment: mdetal.fmb
    (Size: 92.00KB, Downloaded 147 times)
Re: Master Detail Form Error [message #420649 is a reply to message #420637] Tue, 01 September 2009 04:38 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This form works fine when run from Forms Developer 10g connected to the 10g database. (I don't have Forms 6i to test on that version).

[EDIT] Oh, sorry, I didn't notice that MDETAL.FMB wasn't attached by the original poster, but someone else. Nevertheless, the form still works just fine Smile

[Updated on: Tue, 01 September 2009 04:43]

Report message to a moderator

Re: Master Detail Form Error [message #421305 is a reply to message #420649] Mon, 07 September 2009 06:59 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

On using the attached form , I am still getting the same error.
Don't know why and how.
Is there a settig that needs to be done to get this working.

I am attaching the form i have made

Thanks,
Aaabhas
  • Attachment: DEPT.fmb
    (Size: 88.00KB, Downloaded 144 times)
Re: Master Detail Form Error [message #421358 is a reply to message #421305] Mon, 07 September 2009 14:30 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
(After I have created all the missing tables and columns,) form works fine from Forms Developer 10g connected to 10g database.
Re: Master Detail Form Error [message #421419 is a reply to message #421358] Tue, 08 September 2009 04:03 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

Yes Even I had it working with Forms 10g but the error msg i get is with forms 6i.

I need to get this error resolved for FORMS 6i only.
Re: Master Detail Form Error [message #421420 is a reply to message #420362] Tue, 08 September 2009 04:08 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Which version of forms did you use to create the form?
Re: Master Detail Form Error [message #421421 is a reply to message #421420] Tue, 08 September 2009 04:17 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

I used Oraqcle Forms 6i
Re: Master Detail Form Error [message #421424 is a reply to message #421421] Tue, 08 September 2009 04:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which operating system do you use?

Did you install the latest Forms patch (available on Metalink)?
Re: Master Detail Form Error [message #421429 is a reply to message #421424] Tue, 08 September 2009 05:01 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

I am using Windows Xp Pro Edition.
No I haven't installed any patch. Not sure if this would help but can you provide me the patch number so i can download the same and check
Re: Master Detail Form Error [message #421431 is a reply to message #421429] Tue, 08 September 2009 05:02 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd have to search for it, but - that's what you can do by yourself, can't you?
Re: Master Detail Form Error [message #423037 is a reply to message #421429] Mon, 21 September 2009 20:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

You did compile and generate the form didn't you?

David
Re: Master Detail Form Error [message #423070 is a reply to message #420362] Tue, 22 September 2009 00:48 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

No. I was not able to resolve this problem.
Starnge thing though. When i try to run this form on another installation it runs fine.
May be this is an error with my installation.
Re: Master Detail Form Error [message #423104 is a reply to message #423070] Tue, 22 September 2009 02:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You have defined the 'FORMS60_PATH' haven't you?

David
Re: Master Detail Form Error [message #423155 is a reply to message #423104] Tue, 22 September 2009 06:29 Go to previous messageGo to next message
aabhas.bhargava
Messages: 9
Registered: August 2009
Location: Pune
Junior Member

Yes i have
Re: Master Detail Form Error [message #423424 is a reply to message #423155] Thu, 24 September 2009 02:21 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay.

Please confirm that both your machine and the machine on which your forms works are running Forms 6i.

Have the environment variables 'tmp' and 'temp' been defined on your machine and do they point to a directory to which you have write access, is on a local hard drive (not a network drive), and the directory has neither a 'space' in its name, is longer than 32 characters, and there is at less one file in that directory?

Also, in your 'forms60_path', do any of the names have a 'space' in them or are a directory which has no members?

David
Previous Topic: 10g host cmd
Next Topic: How to set font to the word document
Goto Forum:
  


Current Time: Fri Dec 09 03:34:15 CST 2016

Total time taken to generate the page: 0.07639 seconds