Forms_ddl [message #149732] |
Sat, 03 December 2005 11:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abubaker0370
Messages: 9 Registered: November 2005
|
Junior Member |
|
|
I'm trying to use the following command, but it doesn't sees to work:
FORMS_DDL('alter session set optimizer_mode=rule');
by the way, I'm using Forms 6i with Oracle 9i. I would happy if anyone can give any useful information regarding to the problem.
abubaker
|
|
|
|
Re: Forms_ddl [message #150234 is a reply to message #150070] |
Tue, 06 December 2005 19:20 ![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) |
abubaker0370
Messages: 9 Registered: November 2005
|
Junior Member |
|
|
Thanks for your replay.
I haven't sloved yet.
By the way, The Form seems success, because I am using the follwing commands, and no problems occurred:
FORMS_DDL('commit');
IF NOT FORM_SUCCESS THEN
Many Thanks, I will be waiting
abubaker
|
|
|
|
Re: Forms_ddl [message #150257 is a reply to message #150255] |
Tue, 06 December 2005 23:10 ![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) |
abubaker0370
Messages: 9 Registered: November 2005
|
Junior Member |
|
|
Thanks again
The following is the code:begin
FORMS_DDL('alter session set optimizer_mode=rule');
FORMS_DDL('commit');
IF NOT FORM_SUCCESS THEN
SHOW_MESSAGE('The Rule optimizer invoking Failed...');
RAISE FORM_TRIGGER_FAILURE;
exit_form(NO_VALIDATE);
ELSE
SHOW_MESSAGE('The Rule optimizer has been invoked...');
exit_form(NO_VALIDATE);
END IF;
end; what do you mean by (outstanding changes).
the command is not working, because when I connected to the SQLPLUS, and tryed 'show parameter optimizer_mode' command, I got 'choose'
abubaker
Mod-upd: Add code tags.
[Updated on: Wed, 07 December 2005 00:03] by Moderator Report message to a moderator
|
|
|
|
|
Re: Forms_ddl [message #150435 is a reply to message #150279] |
Wed, 07 December 2005 19:27 ![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) |
abubaker0370
Messages: 9 Registered: November 2005
|
Junior Member |
|
|
Do you mean SQLPLUS. by the way, you are right, I checked it and the session changing was not saved, as when I reconnect to SQLPLUS the session return to 'CHOOSE'.
Do you think there is a way to make it;
thanks for all your replys
abubaker
[Updated on: Wed, 07 December 2005 19:27] Report message to a moderator
|
|
|
|
Re: Forms_ddl [message #150463 is a reply to message #150441] |
Thu, 08 December 2005 00:24 ![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) |
abubaker0370
Messages: 9 Registered: November 2005
|
Junior Member |
|
|
David, which parameters do you mean, coz what I want to do is changing the 'optimizer_mode' from the my Form.
However, if you meant that to change the parameter from my Form, I did that and restarted my database, but the parameter return how it was 'CHOOSE';
abubaker
|
|
|
|
|