|
|
Re: how 2 share PL/SQL variable between 2 forms [message #483346 is a reply to message #483333] |
Sat, 20 November 2010 16:32 |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
ORA-06508 is could not find program unit being called. Since the trigger raising the error doesn't call any actual programs that leaves two possibilities:
1) It can't find the pll when running - are you running the forms locally on your pc?
2) It thinks that my_data.department is a procedure or function rather than variable - try writing procedures in the pll to set and get the value of the variable rather than trying to access it directly from the form.
Or you could just use a global variable instead, or a variable in a database package.
|
|
|
Re: how 2 share PL/SQL variable between 2 forms [message #483348 is a reply to message #483346] |
Sat, 20 November 2010 22:58 |
colla
Messages: 36 Registered: January 2010 Location: ksa
|
Member |
|
|
hi cookiemonster
greeeeeeeeeeeeeet appreciate your reply
Quote:It can't find the pll when running
Okay what's your advice
Quote:are you running the forms locally on your pc?
yees this is my personal PC there is no network here.
Quote:It thinks that my_data.department is a procedure or function rather than variable - try writing procedures in the pll to set and get the value
no no no it's a package specification with only one variable
and this is the code
PACKAGE my_data IS
department number;
END;
please download this file and attach it to your Attached Libraries for both forms (Departments & Employees)
http://www.4shared.com/file/AyJVQmqe/shared_data.html
Quote:Or you could just use a global variable instead, or a variable in a database package.
i know cookiemonster i can use a shared global variable or parameter list or global record group but i need your advice to solve this problem pleeeeeeeeez
thanks again
[Updated on: Sat, 20 November 2010 23:01] Report message to a moderator
|
|
|
|
|
|
|
Re: how 2 share PL/SQL variable between 2 forms [message #483358 is a reply to message #483357] |
Sun, 21 November 2010 06:19 |
colla
Messages: 36 Registered: January 2010 Location: ksa
|
Member |
|
|
hi cookiemonster where r u, you leave me
you know what? I remembered when i configure a webutil I should create a .plx file because webutil it's also contain .pll file they are same but i forget . you know
thank you very much cookiemonster
sorry again littlefoot
|
|
|
|
Re: how 2 share PL/SQL variable between 2 forms [message #483461 is a reply to message #483359] |
Mon, 22 November 2010 05:04 |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I think you've got me confused with someone who you pay for assistance.
I've got better things to do on a weekend than hang around waiting for questions from you to answer.
This is a forum of volunteers. We help people as and when we can, but most of us have other things to do as well, including day jobs.
So next time you post a question bear in mind the following:
1) We might not all be online.
2) Those of us who are online might not know the answer to your question. I'm not answering your other thread because I know nothing about OLE2. Hopefully someone else does.
Also can you please stop:
1) Writing words with far more letters than needed - this is a professional forum.
2) Putting messages in the version field - we know you need help, you wouldn't be posting here otherwise, plus the actual version info might be useful.
|
|
|
|