Forms :: How To Hide Oracle In-built Message Which Appears At Bottom Of Window
Mar 18, 2011How to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.
View 2 Replies
ADVERTISEMENT
Forms :: 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 :: How To Built Form (oracle 6i) That Connect With Report Builder
Feb 16, 2013How i can to built form (oracle 6i) that connect with report builder ?
View 2 Replies View RelatedHow To Close Window In Oracle Forms 6i
Nov 27, 2004code for "when button pressed" trigger that will close the current window and displays another window.
View 4 Replies View RelatedForms :: Open Dialog Window Using Oracle 10g
Jul 7, 2012i want to open dialog window using oracle forms 10g on button click event.
View 3 Replies View RelatedForms :: Error Appears In Builder 11g And Weblogic Server
Jan 5, 2011i'm facing a problem when i run form om forms 11g
that error appears :
frm-10142 HTTP listener not running on weblogic on port 80
and when i ran it on weblogic server after compiling it on internet explorer a blank window appear and written DONE
Forms :: How To Handle Position / When Do You Want To Save Changes / Dialogue Box Appears
Jan 22, 2013I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
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.
Oracle 10g IMP - After Tables Are Loaded Procedure Appears To Hang?
Oct 14, 2011 I have an Oracle IMP that seems to complete, but there are two things that I don't understand:
1) The tables seem to load successfully in about 4 hours. After the tables are loaded, the IMP procedure appears to hang for10+ hours. I can query the tables at this time, so I'm not sure what it's doing. Is it maybe applying constraints?Is it normal for applying constraints to take 3-4X as long as importing the data?
2) I see a few of these messages in the alert log during the import.Thread 1 cannot allocate new log, sequence 2754 I don't see errors in the IMP log so are these messages informational or warnings, or will there be something wrong with my imported data?
Forms :: How To Use Duplicate Record Built In
Jun 19, 2012I have one form in which there are master detail blocks. I am entering one record in master block and corresponding entry in detail block. If again I am entering a new record in master block, of course the corresponding entry is getting erased since the block is getting changed.
After entering the data in master block I want to pop a message as 'whether you want to duplicate the same entry in detail block '. If yes, then how can I copy the same details which i have entered for previous record? Can I use duplicate_record built in? If yes, How?
Forms :: Oracle Form Login - No Warning Message After 5 Minutes
Nov 11, 2009Is there any way to make a form timeout.
After login into form if there is no transaction/event happens I want it to throw one warning message after say 5 minutes.
Forms :: Post Built-in Commits Changes In The Database?
May 7, 2010I have been testing out a form using 10.1.2.0.2 on a v10.2.0.1 db and in my local env. the form works correctly i.e. if I make a change and 'post' it and then exit and press NO (when asked to save changes) then it correctly leaves the value in the database as it originally was.
The process works by the user pressing a button in form A (read only form) and this opens form B (using open_mode,session,activate) and the user makes their change(s) in form B (a 'post' command is issued in a When New Rec Inst trigger on a db block when the user navigates to a new record within the same block if it is determined that the block status <> 'QUERY') before returning to form A and pressing 'NO' when prompted to save changes.
However, if I run the same process in the TEST env. using the same executable against the same database then it actually updates the database value.
I have tested this by adding a debug message at the end of form B to retrieve the db value back AFTER having issued a clear_form(no_commit) just for the sake of the test and it still returns me the 'new' i.e. amended value - which is obviously incorrect. From what I can see it would appear that the commit occurs straight after the 'post' has been issued and well before the user even exits the form.
Is this a known bug with the 'post' built-in or could it be that a parameter is set to act in this way (i.e. is there an 'autocommit' setting that is 'ON') within the application server?
Forms :: Anyway To Speed Up Performance Of Go_record Built It
Mar 4, 2010Is there anyway to speed up the performance of the go_record built it or is there an alternative way to do it.
I have a table with nearly 30,000 rows and I would like to implement a text field that will allow the user to jump to a specified record. The only problem is if they try to jump too far away it will take a long time to load (beginning to end of 30,000 takes over a minute).
This problem doesn't arise if all the records, or up to the one they are jumping to, have been fetched already, but even if I fetch all records at the beginning it will still take a long time to initially load them.
Forms :: FRM-40733 - PL/SQL Built-in DBMS_ERROR_CODE Failed
May 28, 2011I have a client who is facing the above error. Everything used to work perfectly but since a week, he gets this error message on a specific FORM. No updates have been made to the FORM.
The FMXs are stored on the database server(10G R3, Windows 2003 R2) and the Client terminals access them through a network drive.When executing the conflicting FORM on the server, no error.
I call the DBMS_ERROR_CODE routine from a FORM-LEVEL ON-ERROR trigger :
DECLARE
ERR NUMBER;
BEGIN
IF DBMS_ERROR_CODE=-1 THEN
MSG('Client existant',ERR,'E');
ELSE
[code]....
Code for procedure MSG :
PROCEDURE MSG(TXT_MSG IN VARCHAR2 , RET_REP OUT NUMBER , TYPE_MSG IN CHAR DEFAULT 'I' ,
LABEL_BUT1 IN VARCHAR2 DEFAULT 'OK' , LABEL_BUT2 IN VARCHAR2 DEFAULT NULL ,
LABEL_BUT3 IN VARCHAR2 DEFAULT NULL) IS
VL_ALERT ALERT;
BEGIN
[code]....
Any Built-in Function (HOST) In Oracle
May 30, 2012 saw in one procedure using host function in below manner.
v_status:= host(v_cmd);
But i searched for the host function it is not available.
My question is --Is there any pre defined built-in function "host" in oracle 10g.
Forms :: Test Legacy Apps Built Using Reports 6i On Windows 7?
Jul 21, 2012I still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
View 11 Replies View RelatedForms :: How To Hide A Button While Runtime
Mar 30, 2012We have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.
Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?
Forms :: Hide Username And Password?
Mar 21, 2011I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:
sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1
So when i run this show me the message:
File 'c: este.rdf=%' not found.
It's showing a '=' sign
Forms :: How To Hide Stacked Canvas
Jan 31, 2012I'd like to hide my stacked canvas. This is my scenario, i have my content and stacked canvas on the same window. When i click a button on the content canvas it will display the stacked canvas, this is the code that i used:
SHOW_VIEW('CV_STACKED');
And on my stacked canvas, i put a button close and fired a when-button-pressed trigger,
HIDE_VIEW('CV_STACKED')
supposedly, it should hide the stacked canvas, but it doesn't hide. i tried SET_VIEW_PROPERTY('CV_STACKED', VISIBLE, PROPERTY_FALSE)
Forms :: How To Hide Text Prompt
Jul 27, 2011I have created a text prompt in layout editor by clicking a button 'TEXT'('A' symbol) from left hand side toolbar,text is created with name 'TEXT67' and graphics type 'TEXT'.
when i click that text(TEXT67),block showing <null>.
So i cant use the below code,bcoz no block for that text..
SET_ITEM_PROPERTY('<BLOCK_NAME>.<TEXT_NAME>',PROMPT_TEXT,' ');
then i tried below,i.e i skip block name i gave only text name..
SET_ITEM_PROPERTY('TEXT67',PROMPT_TEXT,' ');
not working...
Forms :: How To Hide Port From Link
May 4, 2010how to to hide the port number from the linkof my oracle web application???I call my application through a url like:[URL]...
how can I customize this url??
Forms :: How To Hide MENU And TOOL Bar
Jun 22, 2012i want hide the content shown in the picture
View 6 Replies View RelatedForms :: Hide User Name And Password?
May 4, 2010when i want to call report from form how i can hide user name and password from the link in 10g ??
View 1 Replies View RelatedForms :: Hide Menu Bar And Tool Bar Of Browser At Run Time?
Mar 30, 2011i want to hide browsers menu bar and tool bar at form run time and i want to show only form menu in the browser
View 2 Replies View RelatedTotal At Bottom Of Group
Jul 8, 2009I am writing a report that breaks on the first 4 fields. That part is working fine. I also want a count for each Group (the 4 fields), and a grand total. Since I want to break on all 4 fields as if they are one combined field, I made a concatenated column (called Break_key) and had the report total on that.
I was surprised when the count appeared at the top of each group, rather than at the bottom. The grand total is at the very bottom of the report, as I would have thought. How can I get the sub-totals at the bottom, rather than the top?
Report Builder 9.0.4.0.33
My query:
select distinct
fs.FUNDING_SOURCE ,
lpad(l.circuit, 2, '0') circuit,
l.DEPARTMENT ,
l.REIMB_TYPE ,
p.POSITION_NO ,
decode (p.position_type, 'F', 'Full', 'S', 'Shared') position_type ,
ph.phasein,
[Code]....
SQL & PL/SQL :: Total Sum Of Prices At The Bottom
Oct 8, 2010I am displaying customers names and there inventory prices(inv_price * ol_quantity) however I need a total sum of all customer prices at the bottom
ex
name1 | 50
name2 | 25
total amount | $75
DECLARE
CURSOR abc IS
SELECT customer.c_last, SUM(inventory.inv_price * order_line.ol_quantity) AS Total,
inventory.inv_price, order_line.ol_quantity
FROM customer, orders, order_line, inventory
WHERE customer.c_id = orders.c_id AND
[Code]...
I tried SUM(Total) but it can't use that
Forms :: Hide A Single Row Field Of Multi Record Item?
Nov 3, 2010Consider below is a multi record block rows, i want to hide "23". Is it possible using Set_Item_Instance_Property or any other built-in is there in oracle forms to hide a single row field in a multi record block.
11 12 13
21 22 23
31 32 33
. . .
Forms :: Fields Disappear / Hide After Pressing Execute Query?
Feb 15, 2010Something strange happens when i give execute query in a form (Oracle Forms 10g.). On executing query, one field disappeared but when i clicked on the location of the field it appeared again. I am not sure if this has something to do with visual attributes/display properties. This is happening only after migration to 10g.
View 7 Replies View RelatedForms :: How To Hide / Suppress User Defined Alert Messages
Dec 19, 2011Is it possible to hide/suppress an user defined alert message in Oracle Forms application?
View 1 Replies View RelatedForms :: Hide The Data Input When Entered For Security Purposes?
Jan 23, 2013i have a field referring to a password and i need to hide the data input when entered for security purposes.
example if the user enters 1111 the form displays ****