I have 2 10g forms that runs continuousely. They are display screens of scheduled open work, that refreshes as it scrolls. The scrolling is based on a timer, and when it reaches the last record, the forms requeries, and continues on scrollling.
My problem is every few days, both screens that are connected to different PC, stall and stop working we have to manually restart the PCs and the screens work again for few days and the problem happens again..The message we are getting:
end of communication channel, and at the status bar we get: when timer expired raised an undandled exception...Is there a way to handle that exception, can we when it happen, refresh the screen or exit and restart again?
I'm having a problem with the When-timer-Expired trigger.I am creating a timer on the On-Error trigger of the block. in the when-timer-expired :
message (11); exit_form(no_validate);
If i run the program program for the first time,message 11 doesn't show thus it doesn't fire the when-timer-expired trigger. But if i logout from application server and enter all over again,the when-timer-expired works !
One of our Job running long than usual time. I checked the wtait event for which its waiting. its PL/SQL Timer wait. But i noticed the total waits is 179 and timed out is also 179 for PL/SQL Timer. I checked that job that particular procedure calls dbms_lock.sleep in it. I want to know why this wait event is getting timed out ?
I 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.
I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column COL2 -->list value of database column COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).
(1) now the rest of the page will be covered by the third frame in which the fmx's will run.
(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.
Any utility that will take in a string and then search through multiple Oracle Forms and Reports modules (.fmb, .rdf, .mmb, .plx, etc). simultaneously to find which modules have strings that match the search criteria ?
To do this on an individual form is easy enough using the Oracle Forms Developer editor however I have over 100 Forms and reports.
I would like need a utility that will search all Oracle Forms in a given directory without having to actually open a Form(s) in the Oracle Forms Developer editor and then report which Forms may contained the sought after string.
when I try to connect my forms 6i with oracle 9i database, forms stop working and closed immediately at the meanwhile tnslsnr also stop working. This problem also persists in forms runtime.
we have these oracle developer 2000 forms (in .fmx format) in a server and the data of these forms in another server.... the server with the data is very old and is very slow...so we decided to relocate the database(oracle 9i) to a new server..... also, we move the developer 2000 forms from the old server to another server which will serve as the front end to the new data server. how to make the developer 2000 forms on the new front end server to point to the new database on the new data server. how the forms find the data, where this "connection string" is for developer 2000 forms.
I have created a simple master/detail form which is in easy navigation for user. The form have master/detail block with tabular style showing 5 records, When user click on master record the detail will show the opposite as master record point.
Exporting text data from a table. Suppose I have a table of employees.
In oracle Forms. I make the two column of Hire_date1 and Hire_date2. When I put the Date Into Hire_date1 and Hire_date2 , And press push button. All the data save in text file C: emp folder.
I have several forms developed in Oracle forms builder 10g version 9.0.4.0.19. It contains Hierarchical Tree items. when i run this form on this version of oracle, it's running properly. but when i compile and run it on oracle forms 10 version 10.1.2.0.2, it shows an error message stating Assertion Failed!, if I click on the Tree item. I cant find out what and where the problem is. If I build a new form with tree item, it is working properly.
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.
I am working on an application which is on Oracle forms and Reports 6i.It connects to a database which is Oracle 9i. My client wants to upgrade the Database to Oracle 10gR2 or Oracle 11g. I searched in many forums and also saw in Interoperability table which says it is not compatible. But some users are using it fine.
I have windows 7 professional edition 32bit and i have tried to run oracle form 10g on chrome and Mozilla browsers they require plugin but don't install, windows ie8 crashes. i searched through internet about this problem some suggested to use jinitiator, i installed it manually and auto both and also paste the "jvm.dll" but the problem is yet to be solved.
