For passing my apprenticeship I am developing part of an application to change the language of the application dynamically.
My first idea looks like this:
In each form I add a package that works like this:
block := first block
loop
..item := first item
..loop
....set item label or prompt to new language
....exit when item = last item
....item := next item
..end loop
..exit when block = last block
..block := next block
end loop
That far everything is fine. With the get_form_property I can access the first and last block and always get the next block with the get_block_property. Same is true for the items by get_block_property for the first and last item and the get_item_property for the next item. By this way I can dynamically chance all item prompts and labels without knowing the name or the number of blocks and items. But what about radio groups? Is there any possibility (and if yes, which?) to get the first, last and next radio button of a radio group in the same way?
I have a query form where I am attempting to add radio buttons for the user to specify if they want to see Active, Expired, or Both vendors. The existing form is a multirow database block and a single-row detail database block. Users query in the multirow block. I created a QRY_CONTROL non-database block with the radio group and a couple other variables. When they select a radio button, the WHEN-RADIO-CHANGED changes the default block's where clause.
My problem is that the radio buttons cannot be changed in ENTER-QUERY mode. If they cancel the query, the buttons work as expected. I put in a couple messages and the trigger isn't even firing, so I ruled out a code problem I think.I checked to make sure that the group properties are Enabled=true, mouse_navigable=true, query_allowed=true.
i have a radio group(RG) in that group i have two radiobuttons: rb1 and rb2 on a datablock based on a view having display iems 8. i made only one visible i.e rb1. so there is 8 radio buttons displaying in that datablock and when i check one and then another, the previously checked is not unchecked by itself. i need to do when i checked on one then the previous one unchecked itself.
I can't see icons in buttons. I have a custom smartbar and some custom icons on it, and it get displayed, but when it comes to buttons, nothing. Not even the default buttons that comes inside frmall.jar are displayed. What i don't understand is how do they get displayed on the smartbar and not on buttons?
As you can see, i already have the necessary changes to display icons, such as all small case, changes in formsweb.cfg, registry.dat... I get the icons to be displayed in browser. If i put them on a jar file, the jar file is downloaded as i can see in java cache, but never shows. I already tried several different GIF's, different image sizes, different button sizes, colors, names, etc.
We are using ERP based on Oracle 10g forms, there is icons on the buttons those icons are displaying when we uses the ERP in Windows based client and browser Internet Explorer.But when we uses Opera browser we are getting ERP but icons are not displaying.
Same way when we uses Linux client machine using Mozilla Firefox there also the icons are not displaying.
I already have and use .gif files for icons on various buttons in my forms. I need to use a different .gif file to create a new icon. When I enter the file name of the new .gif is not displayed on the button. If I reference an old and working .gif. The .gif appears on the button. What rules if any, must I observe when creating/using .gif files as icons for buttons?
Does the .gif file have to be of a special type? If so, what will I need to do?
I am maintenancing a form which I have to add buttons as headers that will sort each column's data either in desc or asc order when the user click each button. How is this done? I need to know what built-in function that will closely do this or cod.
I found one video on youtube , in that that person has made animated buttons and added analog clocks inside that form but he didn't tell how did he do that , so i am attaching gif file because video file is not allowed , this file will give you whole idea what is actually i am saying.
I just want to to know how to do this , I want coding part for animated buttons and for analog clock only, rest i can do on my own . And this video made me think one thing can we add marque in text in oracle also, as we do in HTML to move text. If it is possible then how can we do that.
I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.
I have a Radio Box Item field in Form, It contain Three Radio Buttons.
During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.
I have one interface form where user will choose radio buttons and based on radio button value different report will run, in one radio button i want to check parameters , for example if there are three radio buttons, a - will run a.rdf ,b- will directly run b.rdf , if user chooses c - then prompt will appear asking him to input from date and to date and based on that value c.rdf will run.
I want this date parameters to run only for this report c.rdf only.One way is to display from date and to date on forms and make it applicable to only this report , but i want to use this parameters only while choose c radio button.
I have a form which contains some block (each block with some text item, two radio groups and a list item). I want to enable/disable and set visible property as true/false for first to last items of each block conditionally. I can do that for all items but radio buttons.
Because to set item or radio button property I need to pass that items ID or Name as parameter. I can get items name/type using get_block_property and next item of that item using get_item_property but unable to get radio button ID/Name using get_radio_button_property or any other built in. To execute get_radio_button_property or set_radio_button_property I need to pass radio button ID/Name. So, how I track radio button id or name in oracle forms? Is it limitations of Oracle forms?
I am working on forms 10g(version 10.1.2.0.2 ) with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on windows 2000 platform. My requirement is to dynamically get the label of the radio button item in a radio group.I am able to get the label of the radio group as shown below
Item :Radio group Label : Gender
IF m_type = 'RADIO GROUP' THEN m_label:=Get_Item_Property(m_Item ,label); END IF;
There two Radio buttons inside this radio group which are item : Radio button Label : Male
item :Radio button Label :female
What is the code to get the label of radio button(i.e) male and female ?
How will I get the count of radio buttons in a radio group at runtime?
i have 2 radio button on my forms and values are A and B. But i have load data from script and against that radio button i have some other values loaded,
When i select query on those records those have other value then radio button, it show nothing. I want to catch that error but there is no error shows. it shows no record to be query. i just want to inform user that that record is not that value which is associated with radio.
i want to get the x-pos of item at the radio-change trigger but it return the error
declare x_pos number; lnum_x_pos number; lnum_width number; begin
if :radio_group = 'E' then lnum_x_pos := Get_item_property('Remarks',x_pos); Message('Position of x...'||lnum_x_pos); lnum_width := get_item_property('Remarks',width); Message('width of remarks field..'||lnum_width);
i have field in DB that taken ( 1 or 2 or 3 ) am added it as text item at first and then change it to ( radio group ) contain 3 radio as :
value for first 1 = 1 , = 2 , = 3 and mapping = 1 initial value for the group = 1
but when am working with the form and commit form there is no data add in this field when am change the radio value by click on any other on ( 2 or 3 ) it's saved no problem in it ..
why this thing happen coz i need to set the first radio as default for the form .
Suppose There are Four options in a Radio Group. From this whichever option I select using the Mouse that option must be Inserted in the Database table field.
How to do this Using Radio Buttons.
Also If I want to select more than One Option Then I use Check Box. For this Also When I select two or three options simultaneously then these values must be Inserted in the Database Table Fields.
how can i get the chosen value in radio button into text item which is in another form?
Suppose i have 3 radio buttons (watch, gadget and jewelry)then I choose watch.How can i display that chosen radio button into the text item which is in another form?
We have access to Professional Dataloader but not to Forms Playback? what Forms Playback functionality would enable to do and why you think this access has been stopped (something to do with accessing Unix) - we are working with a third party
If we have paid for 2 licenses for Professional Dataloader should we have Forms playback?
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production APEX: 4.0.2.00.07 Web-Server: EPG SELECT * FROM NLS_DATABASE_PARAMETERS;
I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error
ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 267 ORA-06512: at "SYS.UTL_SMTP", line 161 ORA-06512: at "SYS.UTL_SMTP", line 197 ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12 ORA-06512: at line 18
is it possible to send mails from oracle database in STANDARD Edition?
While Running the proc,it's raising the below error.
Error report:
ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 246 ORA-06512: at "SYS.UTL_SMTP", line 115 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33 ORA-06512: at line 1
I did an application and i used "Bluejay Theme" and found out that the buttons are distorted when viewing in Google Chrome. Strangely it doesn't happened when viewing in IE or Firefox.