OraFAQ Forum: Forms » Exception ora-06508: attached libraries : please help

Home » Developer & Programmer » Forms » Exception ora-06508: attached libraries : please help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exception ora-06508: attached libraries : please help [message #126657]

Wed, 06 July 2005 02:36

hocnguyen
Messages: 7
Registered: July 2005

Junior Member

Dear all,
i'm new to Oracle Form.
i've created a PL/SQL library named common_lib which has only one procedure hello like this
---------------------------
PACKAGE BODY common_lib IS
procedure hello is
begin
message('hello');
end hello;
END;
---------------------------
i've attached this lib to a form and call this hello procedure in a push button when-button-pressed trigger. Compilation is ok, but when the form runs, it throws an exception: ORA-06508.

i've googled this and found:
---------------------------------------
http://ora-06508.ora-code.com/
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.
------------------------------------------

but i can not find where the mistake is.

i know that this is just a stupid error, please kindly help me.

my email: thanh.hoc@gmail.com

thanks!
Hoc Nguyen

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126658 is a reply to message #126657]

Wed, 06 July 2005 02:40

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Is your pll in the same directory as your form? Is this directory in your FORMS90_PATH?

David

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126662 is a reply to message #126658]

Wed, 06 July 2005 02:46

hocnguyen
Messages: 7
Registered: July 2005

Junior Member

thanks David for your quick response !

> Is your pll in the same directory as your form?

No, forms and libraries are in separate directories.

> Is this directory in your FORMS90_PATH?

Yes, i use forms 6i, and these directories are included in the forms60_path environment variable.

I don't see the .plx file of the lib, only the .pll file ...

thanks !
Hoc Nguyen

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126666 is a reply to message #126662]

Wed, 06 July 2005 02:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Does the name of your directory have a space in it? Have you got the library directory before the form directory? Are any of the direcotires in your forms60_path empty? When you attached the library, did you take the default option of using the full directory name of the library or did you press 'No'?

David

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126673 is a reply to message #126666]

Wed, 06 July 2005 03:10

hocnguyen
Messages: 7
Registered: July 2005

Junior Member

> Does the name of your directory have a space in it?

No. I know that Oracle has problem with directory containing blank.

> Have you got the library directory before the form directory ?

i've created the lib dir after the form dir.
in the forms60_path:
------------------------
FORMS60_PATH=D:\oracle80\FORMS60;D:\oracle80\TOOLS\OPEN60\PLSQLLIB;D:\testproject\lib;D:\testproject\form;
------------------------

> Are any of the direcotires in your forms60_path empty?
absolutely NO

> When you attached the library, did you take the default option of using the full directory name of the library or did you press 'No'?

for the portable reason, i choose 'Yes'

There is sure a stupid mistake !....

Thanks for your patience and kindness !
Hoc Nguyen

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126828 is a reply to message #126673]

Wed, 06 July 2005 18:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

> FORMS60_PATH=D:\oracle80\FORMS60;D:\oracle80\TOOLS\OPEN60\PLSQLLIB;D:\testproject\lib;D:\testproject\form;

I would suggest putting your directories at the beginning of the line. This is opposite to the order you would use for Java paths where your files HAVE to come AFTER the supplied files. And I don't think you need the trailing semi-colon.

David

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126836 is a reply to message #126828]

Wed, 06 July 2005 21:42

hocnguyen
Messages: 7
Registered: July 2005

Junior Member

Thanks David. I've re-ordered the directories as you suggested, and then it works ! That's really great ! Laughing

I'm curious that why you can know the directory order rule ? your own working experience ? thanks a million !

Regards,
Hoc Nguyen

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #126847 is a reply to message #126836]

Wed, 06 July 2005 23:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you re-use the name of an existing Oracle pll? That is a no-no!

Yes ... my own working experience and many people asking me roughly this same question for many years.

David

Report message to a moderator

Re: Exception ora-06508: attached libraries : please help [message #642450 is a reply to message #126847]

Fri, 11 September 2015 02:09

Atreide
Messages: 2
Registered: September 2015
Location: Bilbao

Junior Member

Hello.

Good it did work for you. And a realy good set of things to try. It didn´t work for me though.

What I did was unattaching the library and then compile it and reatach it to the form. Compile (Generate) the form and everything came back to work. I would say it will from now over be my first thing to try. The good news is that the library is actually attached to many other forms, giving all this ORA-06508 error and unattaching/compiling/reattaching/recompiling for one form, made them all work again.

PD. What gave me the clue was that the form would run allright in debug mode and it wouldn't work at all in regular run mode (Green light button) wich didn't make any sense to me (Recognizing libraries in debug mode and not find them at all in regular run mode)

Report message to a moderator

Previous Topic:	Hide 1 option from task bar
Next Topic:	Error 40501

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 04 15:49:27 CDT 2025