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.
ADVERTISEMENT
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 RelatedBackup & Recovery :: Warning Message In Alert Logfile?
Nov 25, 2012I see following warning message in alert log file.
Quote:WARNING: OMF is enabled on this database. Creating a physical standby controlfile, when OMF is enabled on the primary database, requires manual RMAN intervention to resolve OMF datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures describing how to manually resolve OMF datafile pathnames.
Is it just an information or something like warning message we need to look into it.
Oracle Error Message - Click On (Administration) Login Page Is Opening?
Feb 22, 2013i have successfully installed Oracle 10g in Windows 7 ultimate but there is one problem after installation of Oracle 10g an Oracle Enterprise Manager 10g have opened immediately after installation.
when i have sign in with
username: sys
passwd: oracle
connect as: SYSDBA
iam getting this error message
"Error
java.lang.Exception: Exception in sending Request :: null"
& then when i click on "Administration" again the login page is opening.i have tried installing Oracle 10g 4 times this is 5th time .
Forms :: 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 :: 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 :: Create Login Form In 10g?
Jun 17, 2011how to create a login form in forms 10g how upload login.fmb
View 2 Replies View RelatedForms :: Login In Same Form With Different User?
Dec 1, 2010I have a mainform through which one can access 3 different application(say a ,b,c)i have made three push buttons by clicking it the main menu of the respeective application is called.The three applcication have different users(user a,user b,userc)and have different database on the same version(db1,db2,db3 on 111g).I am using formservlet and i am calling the main form. configuration.I dont want the user to enter the username and password so i have hardcored it in formsweg.cfg file. my problem is that i login to the main form as 'user a' so i can access the application'a'.but now if i want to access applicatin 'b' how can i can i login as 'user b'?
View 6 Replies View RelatedForms :: How To Create Login Form
Oct 23, 2013I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.
For example i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.
My requirement is i want to create a basic login form which includes
Login i.e Text_item
Password i.e text_item
Login i.e push button
what should be the queries behind these items. and how to connect this form to database. I am attaching file , just add working codes in that or you can write codes here also .
Creating Login Form In Oracle
Feb 25, 2010Creating Login Form In Oracle.
View 2 Replies View RelatedForms :: User Defined Login Form
May 3, 2011I have designed a Login form which takes username, password and connect string is hardcoded.I have compiled it, made an fmx file. created a shortcut to desktop. given the BIN path in shortcut.
when i want to lauch it, oracle's default login popup is shown.It can be by passed while defining username/password@string in shortcut properties but it reveals the password. every one can access it. I want to launch my own form without logging in to oracle. how can i avoid default login popup?
Forms :: Create Login Form With Validation
Dec 4, 2010I just need to create a login form ..its like user will login using his given id and password will be encryted when entering and i just need to simple validation that if he has entered corrected password it will display message ok or else wrong password.
View 3 Replies View RelatedForms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message
Jan 15, 2013I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".
I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.
Forms :: Database Connectivity After Putting Customized Login Form
Feb 12, 2010I am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.
My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.
The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.
Forms :: How To Catch Warning / Error ORA-28002 In Oracle
Dec 6, 2010SQL > conn ashish/pass@conn_string
ERROR:
ORA-28002: the password will expire within 1 days
----------------------------------------------------------
I want to catch this eror in forms: catch the error code ORA-28002 in ON-ERROR trigger and ON-Message trigger, however its not getting caught in the trigger. how to catch the warning/error ORA-28002 in oracle forms?
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.
Application Express :: 4.1.1 - Tabular Form Updated Row Message
Oct 31, 2012In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:
16 rows updated, 0 rows inserted (the standard message).
I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.
Here are some info regarding my tabular form:
8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.
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 View RelatedForms :: Bypass Login With Oracle Database
Feb 20, 2013I am using Oracle forms 6i. I want to create an application that does not require any connection with Oracle database. My Application fetch all its data from an Excel file. I do not want Login with Database,so i want to bypass it. How can i do it ?
View 6 Replies View RelatedForms :: How To Connect Excel With Oracle Database Via 10g Login Screen
Jul 20, 2010In fact I have around 50 excelbooks that are connect with oracle via ODBC/or any other way. My task is to build the login screen on form 10g. This form will validate the user via .dll after successfully validation, Form will connect to specific oracle user. This Login Screen will call the new form that will execute the query for the list of excel sheet [table that will keep the name, description and path of the excelbook]. User will select the one excelbook to open. As user will select Excelbook should be open. Now this excel book should be connected with specific oracle user.
Question 1: How to open the excelbook, that excelbook should be connected via form 10g login screen. After connection excel has its own micros to run he query from oracle database.
Question 2: How I can create the mirco into form 10g to run into excelbook/excelsheet.
Question 3: How I can pass the query or function/procedure to the excelbook/excelsheet.
Forms :: Login As SYSDBA In Oracle From Normal Logon Procedure?
Apr 24, 2012is it possible to login as SYSDBA in oracle forms from normal logon procedure?
logon(sys_acc, sys_pwd||'@'||:GLOBAL.db_conn);
The reason behind this is to make a form which will alter user's password. But all the users are in SYS account and it is necessary to login as SYSDBA in forms to execute alter statement.
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Application Express :: Raise Warning When Password Due To Expire - Oracle Database Users
Aug 23, 2012Using Apex 4.1 and custom authentication based on Oracle Database users.
I want to be able to show a warning immediately after a user logs in if their password is due to expire in xx days. Oracle raises a warning (ORA-28002) but I don't know how to handle that from the standard Apex login page.
Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black
Sep 23, 2011I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
Forms :: Adding Hours And Minutes To Time
Feb 11, 2011I currently have a problem where I have two date fields with time stamps. The only bit i am currently interested in in these fields is the time factor. When i display them in their field they have a format of HH24:MI .
I have a start time and end time as well as a duration and duration type. What I am trying to do is the following: when the user inputs the start time, along with the duration say 1 for example and the duration type of say HRS for example I would like to have the end_datetime default to 1 HR from the current start time. This is the code I use on a when validate item trigger to acheive this:
case :blk.duration_type
when 'HRS' then
:blk.end_datetime := :blk.start_datetime + ((1/24)* :blk.duration);
when 'MINS' then
:blk.end_datetime := :blk.start_datetime + ((1/24/60)* :blk.duration);
However, every time it triggers the value put into end_datetime is 0:00 is it something to do with the datatypes im using .
Forms :: Migration Of Oracle Form 10g To 6i?
Apr 19, 2011Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.
View 1 Replies View RelatedForms :: Matrix Form In Oracle
May 20, 2013Is there any possibilities to make matrix form just like matrix report.
one is the month column which increase horizontally other is emp_name column which increase vertically and sal column which show the salary of each employee in each month.
Forms :: Why Other Browser Cannot Run Oracle Form Without IE
Oct 9, 2012Why Other Browser cannot run oracle forms without IE.
i want to use other browser for oracle form like firefox,google chrome etc not IE.
Forms :: How To Convert Oracle 10g Form To 6i
Oct 24, 2013How to convert Oracle 10g Forms to Oracle 6i Forms ?
View 2 Replies View RelatedForms :: Oracle Form Entry?
Feb 25, 2010i am new to oracle form , i am using orcale 10g forms, i have following requirements.
1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).
i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form