Forms :: Changing Message Type
Nov 14, 2011Some time we use message function in oracle forms.
message('...');
can we change the type of this message? Icon should be caution instead of Stop.
ADVERTISEMENT
Forms :: Showing Message When Canvas Changing?
Jan 6, 2012 I am facing one confusion with canvas changing and message displaying issue i have one login page. in that there are three fields username,password and department in the department i having 5 departments including salesandmarketing
the requirement once i entered every credentials correctly and i am logging in as salesandmarketing. When the salesandmarketing canvas opens a message should display saying "you are successfully entered into sales and marketing".
i have my home page as content canvas and sales and marketing as tab canvasi need to do the same message when i am entering into 5 departments with corresponding department name in the message end instead of salesandmarketing
is it possible to do with when_new_canvas
Forms :: Declare Message For @ Is Not Type In Email Address
Oct 24, 2011i want if user is not type the @ in email text box than from show the message "check your email address" but i cant do that
declare
ok_flag number :=0;
begin
ok_flag :=instr('emailaddress','@');
if
ok_flag < 1 then
message('invalid email');
else
message('thanks');
end if;
end;
SQL & PL/SQL :: Converting XML Message To Record Type
Apr 8, 2010We have a queue in which the message is coming from external system. The payload of the queue table is a PL/SQL record type. Once we get the message in the queue, we de-queue the message and read through the PL/SQL type collection and process the message.
From the below query, we are able to convert the PL/SQL collection message to XML message and see the data.
SELECT dbms_xmlgen.getxml
('SELECT USER_DATA
FROM <Queue_table> X
WHERE X.USER_DATA.SALE_ORDER.P_HEADER_REC.ORIG_SYS_DOCUMENT_REF=800501298')
FROM dual;
The new requirement is the message would come in a XML message in the queue. So my question is, is there any way through which the XML message can be converted to the PL/SQL record structure directly (it would be the opposite operation of the above query).
SQL & PL/SQL :: Changing DATE Type?
Oct 25, 2011oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
In the database, NLS_DATE_FORMAT = DD-MON-RR.I have a date field called LOAD_DATE in one of the tables. I want to store the value as '25-OCT-11 01:16:25 PM' in LOAD_DATE field. Is there a way to do it without changing the NLS parameter (ALTER SESSION...) ?
SQL & PL/SQL :: Changing Field Type In Oracle Table
Dec 13, 2011I have uploaded some tables from MS Access to Oracle and in the process, some Number fields have been converted to Text. This means that any Queries where there are calculations with those fields (which have been converted to text) don't work properly anymore.
I would like to change the field type from text to number (with cmd and sqlplus) as that's the only way I can access the oracle backend.
I am not sure what commands to use to change this.
Also, if I change the data type from text to number, is it likely I will lose some data?
And how do I backup the table before I do this?
Client Tools :: Date Format And Calendar Type Are Not Changing In Oracle Form?
Oct 30, 2011i have changed date's format and the calendar type in sqlplus through the following command so the date's format and the calender type both changed successfully and work, but in oracle form the they haven't changed.
alter session set nls_calendar='persian';
ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD';
ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD' SCOPE=SPFILE;
Note: i know session would change the format temporally but i want to change it permanently so i tried alter_system but still no result
Application Express :: Changing Sequence In Content Frame Not Changing Ordering Of Regions
Apr 24, 2013Using Application Express 4.2.1.00.08
Any problem using 4.2's One Level Tabs - Content Frame page where you have a parent region (of type content frame Body Container ) while number of child regions (of type Hide & Show Region - Borderless ), if you want to re-order them by changing the sequence, it has no effect when you run the page.
The regions still show in the same order top to bottom as it did before the update of sequences. Heading links (to show/hide child regons in content frames) has the same ordering as before.
Forms :: Clear Block Message In Oracle Forms?
Nov 30, 2012I am creating a form with 3 blocks.
Control block,
Header Block,
Detail Block.
First i have entered a record in the control block.
Then i navigate to header block,entered the first record for Header Block.
Then i navigate to Detail block,entered the first record for detail Block.
then i again navigate to Header Block..
Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".
Condition 1:i dont want that message to appear for every header record i enter.
Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.
Forms :: Message Is Not Displaying?
Feb 14, 2012i got an error running my form. And when i re-run it again, the message at the bottom was nowhere to be found. How can i bring it back?
View 3 Replies View RelatedForms :: Message From Webutil?
Apr 3, 2012I'm migrating some forms from 6i to 9i and one of them has to use the webutil library, but when I execute the form in the IE, a message appear and I don't know from where because I haven't made it. The message say: "Confirme el mensaje" This is a print of the message,
View 3 Replies View RelatedForms :: How To Avoid FRM-40401 Message
Oct 16, 2008While I am inserting and updating the values in the oracle database its showing a message 'FRM-40401 - No changes to save.' I don't want this message to be shown. How can I do that?
View 5 Replies View RelatedForms :: How To Stop System Message
Nov 3, 2010I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
View 3 Replies View RelatedForms :: How To Remove Message That Come Automatically
Mar 2, 2010How can I remove (record asved) message that come automatically after commit??
View 5 Replies View RelatedForms :: How To Hide Pause Message
Jul 20, 2010I need to hid the PAUSE Message "Please acknowledge". when I use PAUSE key word and replace it with another message
View 1 Replies View RelatedForms :: Change Background To Logo Message
Jun 30, 2010I want to change the Background "Oracle Forms AS services" to one of our logo. I searched in formsweb.cfg and tried many parameters. I got succeeded in changing Title, forms background but not able to change the oracle logo message in the white background of html web page.
View 2 Replies View RelatedForms :: Show The Message In Form Personalization
Aug 9, 2010I call the one procedure in post_insert which submit the concurrent request and send the email to specific email address. Now i want to show the message, when email is send that "Your msg is send to ....."
View 5 Replies View RelatedForms :: Error Message - Could Not Reserve Record (2 Tries) Keep Trying
Apr 21, 2011when i running my form i m receiving this error message Error Message is "Could not reserve record (2 tries) keep trying ? " This is due to multi user Login, How can i avoid from this error message.
View 26 Replies View RelatedForms :: Form Generate Message Frm-40654
Sep 1, 2011what is this error.it will come on after save record on table through form.
FRM-40654:Record has been updated by another user.Re-query to see change
Forms :: Changing The Colour Of Item?
Aug 5, 2010For eg. If I want to change the background colour of Item it can be done in 6i using set_item_property builtin and can be written in mouse enter trigger. In Forms 10g when_mouse_enter trigger not be used.
How to implement the same funtionality or FOrms 10g.
Forms :: Before / While Changing - Display All Records?
Jun 22, 2011 I have created two tabs tab1 & tab2. after changed(not while changing/before changing)) into tab2 all records should be display.
I have written execute_query in when-tab-page-changed.but that is before/while changing.i want after entered in tab2 it should be display.
Forms :: Displaying A Warning Message If No Detail Saved
Jul 25, 2011I have 2 blocks, block 1 which is the master and block 2 which is the detail. Both block 1 and block 2 are multi record blocks. For my form I want to display a warning message to the user if they create a master block without also creating a detail.
View 2 Replies View RelatedForms :: Send Message To Lantronix Network Device?
Sep 15, 2011how I can send a message from Oracle Forms 10g to a Lantronix terminal server? It is a TCP/IP front end to a serial port controlling a warehouse carousel. We want to send a command string to a ip_address:port_number in raw mode. We have tested it using a telnet session. I develop in PL/SQL, just never used forms.
View 2 Replies View RelatedForms :: 10g - Send Text Message To GSM Mobile Device?
Aug 28, 2010through oracle forms 10g how can i send a text message to a GSM mobile device...
View 2 Replies View RelatedForms :: Changing Record Group For LOV At Run Time
Dec 2, 2008I have 2 record groups names RG1,RG2 , I attached RG1 record group to LOV1 at design time,I want to change the record group RG1 to RG2 for LOV1 at run time.
View 11 Replies View RelatedForms :: Changing A Block Not Base Table
Oct 15, 2012How do I change the status of a block to change?
View 7 Replies View RelatedForms :: Changing LOV Based On Some Other Text Item?
Apr 18, 2013I got a required to show LOV or list ... based on some value in other column. suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc//
View 2 Replies View RelatedForms :: Dynamically Changing The Record Group?
Nov 17, 2011I am working on forms 6i, ebs 11i and data base 9i. I have below requirement to achieve.
I want to create a lov for a column called 'FORM'.
I have lookup for this as follows
lookup code meaning description
FORM FORM XXSMCINV_FORM
in the description, it's value set name.
I am manually checking the value set name and writing static record group.
Right now, i have static record group for this like below.
select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM' order by flex_value;
It's working fine.
But in the lookup, they can add one more FORM like below.
LOOKUP_CODE MEANING DESCRIPTION
FORM FORM XXSMCINV_FORM
FORM1 FORM1 XXSMCINV_FORM1
Now i have to change the record group query manullay like below.
select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM' order by flex_value;
UNION
select ffvv.flex_value "FORM"
from fnd_flex_value_sets ffvs,fnd_flex_values_vl ffvv
where ffvs.flex_value_set_id=ffvv.flex_value_set_id
and ffvs.flex_value_set_name='XXSMCINV_FORM1' order by flex_value;
Is there anyway i can make this automatic whenever they add new FORM lookup.
Is this possible to achieve using dynamic record group.
Forms :: Changing Button Color At Runtime?
Jan 21, 2012i want to change the button color in the runtime. is it possible by using set_item_property. if not, can we set by using property palette at design time.
i tried by setting the property in both ways but it's not working.
Forms :: Changing Text In A Display Item
Dec 20, 2010I have text in a display item on my Oracle Form. When my user hovers over the text with my mouse I want it to show my user that the text is active. The text may change color(no tool tip).
Is this possible?
Environment: Client / Server