| Global Variables [message #247060] |
Sat, 23 June 2007 06:35  |
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 #247431 is a reply to message #247060] |
Mon, 25 June 2007 21:12  |
|
|
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 #252965 is a reply to message #252544] |
Sat, 21 July 2007 01:07 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
