Incorrect result on assignment statement [message #497003] |
Thu, 03 March 2011 11:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dwilbur3
Messages: 9 Registered: September 2008 Location: Sacramento, CA
|
Junior Member |
|
|
I apologize if this has been answered before, but I couldn't find it with a search.
Yesterday my desktop development environment was working just fine, but today it has a crazy bug.
When I run a menu (which was working fine yesterday and hasn't been changed in months) I click on an item and it runs the following code:
"
DECLARE
module_name VARCHAR2(125);
BEGIN
module_name := :GLOBAL.FORMS_PATH || 'covenants';
Open_Form(module_name);
END;
"
The module_name variable should be assigned the value 'covenants', because :GLOBAL.FORMS_PATH is '' (nothing). I stepped thru the code and in the debug system values window there is nothing in :GLOBAL.FORMS_PATH. But instead, it gives me:
'FORM_NAMEcovenants' where 'FORM_NAME' is the form the menu was called from.
Has anyone else encountered this. If so, how do I fix it?
Thank you,
Don Wilbur
|
|
|
|
Re: Incorrect result on assignment statement [message #497011 is a reply to message #497007] |
Thu, 03 March 2011 12:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dwilbur3
Messages: 9 Registered: September 2008 Location: Sacramento, CA
|
Junior Member |
|
|
Yes, I recompiled, I rebooted, I renamed the form.
As to how nothing becomes something, that's what I would like to know. It's inserting the form name even tho the form name isn't in the :GLOBAL.FORM_PATH variable. I'm stumped.
|
|
|
|
Re: Incorrect result on assignment statement [message #497018 is a reply to message #497014] |
Thu, 03 March 2011 12:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dwilbur3
Messages: 9 Registered: September 2008 Location: Sacramento, CA
|
Junior Member |
|
|
I'm running it locally.
I load the login form, which loads the menu. Then I choose a menu item which triggers the code above.
And now the problem goes away just as mysteriously as it came. I added a message, then it ran fine. I remove the message and it still runs fine.
This so bizarre. I don't know what caused the problem and I don't know why it went away.
At least it went away.
|
|
|
|