Forms :: Changes Made Not Getting Effected In Front End
Mar 16, 2011
I am new to oracle 10g. I have a strange problem which i never used to face it while using oracle 8i.
Out of around 120 forms , there is 2 forms in which all the data entry is being done. any changes made to the coding / text in these fmb is not getting effected when i run the form through front end.The front end is developer 2000 .
Where as changes made to the other fmb is working perfectly fine. Is there any deployment issues which needs to be taken care off in oracle 10g.
I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.I have a range partitioned table having lobs as basicfile. Due to storage issue and other business constraints , it is determined not to change existing lobs to securefile.
However ,we want new lobs to be in securefile and alter table to haveĀ interval partition+.While researching, I found sql to change lob in range partition to securefile by using
alter table t1 add partition t1_p2 value less than (10000) lob (col3) store as securefile (tablespace tbs_sf1)
What to do similarĀ in case of interval partition.
i want to find the name of user who make changes in the table structure or create any index or constraint or unique key or alter the column? Is there any way to find in Oracle. in which table what change has been done as well?
following Output needed
userid, username, schemaname, schemachangetime, "what_change_has_been_made", IP address or Computername
insert into call values(1,9818764535,9899875643,'IN','24-APR-13 02:10:43',10); insert into call values(1,9818764535,9898324234,'IN','24-APR-13 05:06:78',10); insert into call values(1,9818764535,9215468734,'IN','24-APR-13 15:06:78',10); insert into call values(1,9818764535,9899875643,'OUT','25-APR-13 01:06:78',10); insert into call values(1,9899875643,9899875643,,'OUT','25-APR-13 22:06:78',10);
Query : need to find first and last call of '9818764535' mobile number and of call_date between '24-apr-13' and '25-apr-13';
I am trying to login through front end application. I am getting the error login failed.
I tried to login from back end using same USERID and password. In the login page it's asking for EDUSERID and password. I tried to connect from backend to the database using same EDUSERID and password and it's working fine. But why from front end application I am unable to login.
I am hoping to test the behavior of a complex web application that is backended by an Oracle 9i database, against an upgrade to 11g database.
The current setup runs basically on 4 Solaris servers, The database, the Oracle Application Server (version 10 something) (2 instances running on the node/server with no OHS), an install of OAS/OHS as a load balancer box, and the non-OHS Apache2 web server front. Apache takes the request from the web and reverse-proxies it to the OHS load balancer, which sends it to one of the two instances on the single application server. This is a java application and uses an Oracle 9i database to feed it.
I have had enough server resources to clone the database, the app server and the web server, and upgrade the database to 11g. I am unable to setup an OHS load balancer box.
So my question is, how do I configure the Apache WS to communicate directly with the OC4J container(s). I can shut down an instance if that simplifies things. Or, if I had to I could look into standing up OHS in the OAS install, as that seems to be where all the info is focused on the technical info sites (Oracle and others), but since these are clones and I think it might be easier to just short circuit around the now missing load balancer box. Many configurations have already been done to be sure the 'clone' identifications are self-referencing, like the hosts file, etc. to point to resources in the Cloned environment.
I am trying to write which will return cursors to front end program.The logic which I got stuck is while exiting the procedure.I am having some cursors in teh procedures which are read by the front end script.I have one condition which when satisfied I have to exit from the procedure.But the constraint I am facing is if I exit at that logic, oracle closes all the cursor and front end script is not able to read teh cursor and hence throws an error.Is there any way to exit the procedure without closing the REF cursors.
I am trying to generate a software that used VB as the front end and Oracle 10G as the back end. I have noticed that the date format is VB is : m/dd/yyyy whereas the date format in oracle is dd-mm-yyyy. Whenever i try to insert a tuple with either of the date formats, the program halts running and after a long time , i get a message saying a deadlock was encountered. I have never had any formal introduction to either of the two tools
I am running Apex 4.2 on Oracle Express Edition (Linux). Sometimes my login page has the alignments of the Workspace/username/password login area below the Apex image as below: [URL] ........
This is with using Firefox. The font page renders ok with other browsers like IE or Chrome.
Users use front end (called ESS Console) and when they try to open one of those tables they wait very long (really bad performance). Sometimes the GUI even hanging without displaying results.
Does Partitioned Tables feature works for better performance?
When you create a backup in SQL Server, whether the backup is on disk or on tape, SQL Server writes the letters TAPE to the first four bytes of the backup. Does Oracle write any specify value to the front of every backup, and if so, what are the first four bytes?
I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
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.
I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.
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.
I would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i
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 are using Oracle Forms 6i and back-end as Oracle 10g Database. We are facing a specific problem while working with Forms6i. I am giving the steps as showm below:
1. We have a table named TEST (a number not null, b char(1) not null). 2. When we insert a record throuhg SQL*PLUS like this: insert into test values (1, ' '). The record is inserted in the table TEST successfully. 3. We checked the length of column b i.e. select length(b) from test, it is showing 1. This is the correct value because it has inserted a space in column 'b' of the table TEST. (That's what we want). 4. We created a form having data-block from table TEST and trying to insert the same record throuhg Forms9i. 5. There it gives an error of "Unable to INSERT record" becuase in form builder, it is trimming the spaces for column 'b' automatically and making it NULL. Since the column 'b' defined as NOT NULL in table TEST, hence generating the error. (Basically there in form builder, it is generating ORA-01400 error which is can not insert NULL value in NOT NULL column).
We would like to know why in form builder, space is automatically being trimmed to NULL..? We do not want this to happen. We want space to be inserted as space only. How can i implement this case, becuase we need this kind of functionality in our form builder application.
I have a problem running forms 11g OS is windows 7 (tried on both 32bit and 64 bit same error)..Forms and Reports were both working fine, i was able to run test form, and a form that i created, and both were running properly. suddenly, while testing a new form module, it didn't work, and its showing :
Failure of server APACHE bridge: ------------------------------------------------------------------------------ No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
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.