Home » Developer & Programmer » Forms » Global Variables
Global Variables [message #247060] Sat, 23 June 2007 06:35 Go to next message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
I am using Forms6i, there are some procedures created in pl/sql libraries using many global variables, and when the procedures are executed, the result is zero from all global variables, after that when these libraries are recompiled and regenerated again then the result will be good, then if these procedures are executed again, suddenly the result will be zero, then again the libraries should be recompiled and regenerated many times to get the correct result, How can I solve the problem?
Re: Global Variables [message #247240 is a reply to message #247060] Mon, 25 June 2007 03:46 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

What happened if you re-attached that library in your form?
Re: Global Variables [message #247289 is a reply to message #247240] Mon, 25 June 2007 06:53 Go to previous messageGo to next message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
Even i did that many times, and still i am facing the same problem.
Re: Global Variables [message #247431 is a reply to message #247060] Mon, 25 June 2007 21:12 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Don't use global variables now on passing values to your library. Just pass that global variable as parameter. Or, if this is about to take a lot of your time, then use package as handler of those global variables. I mean package spec. for example:
PACKAGE variables IS
  globalVar1     VARCHAR2(1) := 'N';
  globalVar2     VARCHAR2(1) := 'N';
END;

..Just make sure to have this same package spec on your library, with "strictly" same order of variables or your variables will overwrite the other.

Hope this help.
Re: Global Variables [message #247465 is a reply to message #247431] Tue, 26 June 2007 00:49 Go to previous messageGo to next message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
it is exactly the same manner
Re: Global Variables [message #249095 is a reply to message #247465] Tue, 03 July 2007 06:33 Go to previous messageGo to next message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
Is there any solution from any body?
Re: Global Variables [message #252544 is a reply to message #249095] Thu, 19 July 2007 02:44 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?

David
Re: Global Variables [message #252965 is a reply to message #252544] Sat, 21 July 2007 01:07 Go to previous messageGo to next message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
Firstly Thanks to Wency and Thakyou very much for your response, and Yes I have solved the problem, as advised by Wency earlier, fistly I have re-attached only those libraries where I was facing the problem and when I found the problem again then I re-attached all libraries of the whole application, and after that till now I did not get the problem again.


Re: Global Variables [message #253188 is a reply to message #252965] Mon, 23 July 2007 01:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It sounds as though you have calls from one library to another library. If so, (1) make sure that you do not have circular calls, that is, library A has a call to library B and library B has a call to library A and (2) consider attaching library A to library B and ONLY attaching library B to your form (library B will attach library A for you)

David
Re: Global Variables [message #254977 is a reply to message #253188] Mon, 30 July 2007 04:38 Go to previous message
sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia
Junior Member
Thank you David.
Previous Topic: How to hide dialog window?
Next Topic: Form property doubt
Goto Forum:
  


Current Time: Fri Dec 09 23:01:01 CST 2016

Total time taken to generate the page: 0.25485 seconds