Forms :: Use Features Of Utl_file In Oracle Forms
Apr 3, 2011can we use features of utl_file in oracle forms.
View 2 Repliescan we use features of utl_file in oracle forms.
View 2 RepliesI read previous post "Can I use the latest features in Oracle Developer Tools 11g and still use ODP.NET version 10.x or 9.x in my application?".In this the solution was: "Solution: Yes, you can use the newest 11g version of Oracle Developer Tools while developing code that relies on ODP.NET version 10g or 9i. In almost all cases it will work fine. The only exception is with the automatic .NET code generation feature. Here is what you need to do:
a) Install both ODT 11g *and* ODP.NET 10g or 9i. They must be placed in different Oracle Homes!
b) You will now be able to use the 11g Oracle Developer Tools for Visual Studio and all of the newest features. To ensure the correct version of ODP.NET is used by your application continue to the next steps:
c) Make sure that in the "References" section in your solution, the Oracle.DataAccess.dll that is referenced is coming from the Oracle 10 or Oracle 9 Oracle home.
d) Finally, you must "ungac" (gacutil /u) the ODP.NET 11g policy DLL's or else your application will silently begin using the 11g version of ODP.NET even though the reference points to the correct DLL. There are several Oracle policy DLLs with varying names, for example: "Policy.2.102.Oracle.DataAccess.dll". Ungac them all."
Are the steps the same if i have Oracle Developer Tools 12c and still use ODP.NET version 11g R2 in my application?
I have make utl_file. Its run in oracle 10 g. But when i run oracle 9i it give some error.
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at "SYS.UTL_FILE", line 204
ORA-06512: at "HR.EXP_DATA", line 9
ORA-06512: at line 1.
[code]......
oracle 9i, I am reading about UTL_FILE package.make this in Hr Schema.Where hire date between date 1 and date 2.
View 8 Replies View RelatedI would like to check and make sure that features like partitioning, Tuning, Diagnostics etc. have NOT been used. In Oracle 10 + we have the dba_feature_usage_statistics.
But how can we check this in 9.2 ?
I got a couple of reports that are made as .CSV files from PL/SQL. However I am lacking some design features. Is it possible to define text + background color and height + width of fields? (I am using utl_file package.)
View 4 Replies View RelatedWhat are the default features available along with 10g R2 Enterprise Edition , Especially for RMAN Backup ? What are the features required for licensing in 10g R2 EE version .
View 2 Replies View RelatedI want to remove some db features and options from our production database:
- Virtual Private Database
- XML DB
- XStreams
For removing of XML DB I have found: XML DB FAQ. Is it still actual? But I found nothing for uninstalling of VPD and XStreams.
Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedI 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 a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
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.
How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View Relatedwhen 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.
View 6 Replies View Relatedwe 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.
View 1 Replies View RelatedI 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.
See attached file.
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 created a form to create a username and password.i tried creating a user in forms 6i using the following code on the when button pressed trigger:
BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;
i have granted the user to create user but it does not work at all. password and user_name are captured in the form.
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.
View 1 Replies View RelatedI have a LOV in a custom oracle forms.this lov is linked to a record group.
Presently the column on which lov is created does not contain any value.
I want to insert value into the lov through the forms.
I am not able to insert data into it through forms
I 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.
I am creating a procedure oracle forms and database Which one is fires first ..If suppose i need data base fires first...
View 3 Replies View RelatedHow to Install Oracle Forms and Reports 11g Send me Link or Document.
View 4 Replies View RelatedCould I install Oracle 10g forms on windows 7?
View 1 Replies View RelatedHow can i get data from Ref cursor on Oracle forms?
View 1 Replies View Relatedi want some information about the oracle developer 11g ( froms & reports) . if oracle developer 11g and oracle is both are similar ?.
View 5 Replies View RelatedI would like to display PDFs in Oracle Forms. The PDFs are stored in an Oracle 10g database.
View 2 Replies View RelatedHow to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
View 4 Replies View Related