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

Report message to a moderator

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: 21818
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.

Report message to a moderator

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?

Report message to a moderator

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: 21818
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.

Report message to a moderator

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 1024 times)

Report message to a moderator

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: 21818
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 1054 times)

Report message to a moderator

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: 21818
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.

Report message to a moderator

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.

Report message to a moderator

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: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Which version of forms did you use to create the form?

Report message to a moderator

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

Report message to a moderator

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: 21818
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)?

Report message to a moderator

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

Report message to a moderator

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: 21818
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?

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

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

David

Report message to a moderator

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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You have defined the 'FORMS60_PATH' haven't you?

David

Report message to a moderator

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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:49:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.