Forms :: Saving Excel Files As Object In Oracle?
Feb 13, 2012How can we save Excel file as an objectin oracle. Like we can store image file.
View 1 Replies
ADVERTISEMENT
Forms :: Saving The Object Group
Dec 13, 2010I've created Object Group which consists of (alert, parameters, visual attribute and property class). Now I want to save this Object Group.
View 3 Replies View RelatedForms :: DDE Package - How To Close Excel File Without Saving Changes / Messages
Nov 19, 2009I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.
I am using THe DDE package and when using
DDE.EXECUTE(convid, '[Save()]', 10000);
there is no problem, but the changes are saved. I have tried '[Exit()]' and '[Close()]' but always have error message ORA-106555. Is there any way of doing this without errors?
Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases
Mar 5, 2013what type of storage systems used for saving archive files and backup files "especially for oracle databases"
View 5 Replies View RelatedForms :: Unable To Create Object For Excel 2007 / Windows 7?
Aug 11, 2010The below Oracle Forms code works fine for Excel 2003/Windows XP/IE6 but doesn't work for Excel 2007/Windows 7/IE8.
*********************
application := Client_OLE2.CREATE_OBJ('Excel.Application');
Client_OLE2.SET_PROPERTY(application,'Visible','TRUE');
workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');
args1 := Client_OLE2.create_arglist;
************************
There is no error while executing the form, by debugging we found that the control skips all the above code.
I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.
Forms :: Webutil EXCEL Download CLIENT_OLE2 Stops When Create Object
May 22, 2010When Running forms on local machine I successfully download data to excel. But when I place this to server (unix), the forms stops in this line: application := Client_OLE2.create_obj('Excel.Application');
I think I have no problem with webutil setup or signing it including the jacob because another form is running on server with webutil functions loading and downloading images (pdf).
The problem is why when it comes to excel I have this issue. When I run the form and the code mentioned above is encountered, the program stops. What I have on java console are:
Loading http://59.0.0.132:7778/forms/java/frmall_jinit.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/frmwebutil.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/jacob.jar from JAR cache
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.0
[code]....
Forms :: How To Export SQL To MS Excel Using CSV Files
Jul 17, 2013I create this because I need a way to export SQL commands in several forms to Excel without using CSV files. So this routine opens MS-Excel automaticaly and then export the data of the SQL into a sheet within the excel. Is a procedure that can be use in any form and using simple or complex SQLs.
I compressed 3 files in the TXT file. So, first change the extension from TXT to RAR and then unzipped the file.
SQL & PL/SQL :: Transfer Excel Files From Unix To Oracle Database?
Jun 6, 2013I would like to ask you if you know which built-in can I use for transferring a excel file from our Unix box to a table in oracle database, right now we are using webutil_file_transfer.Client_To_DB_with_progress using forms developer, but I need to run as an automatic process uploading form unix into oracle directly without using forms.
View 22 Replies View RelatedForms :: Create A Form To Store Any Excel / Word Files?
Jul 1, 2011i m using oracle 10g forms.
i want to create a form where i can store any excel / word etc files.
PL/SQL :: Text Fields Getting Disappeared After Saving In Oracle Forms?
Mar 1, 2013I have developed a screen using oracle forms.... it has 4 text fields..then a LOAD button.After giving i/p in the 4 text boxes user will save (ctl+S) ..then hit LOAD button ,which will populate the fields below the screen.Everything is working fine but only problem I am facing...when user is trying to save (ctl+S) after giving the 4 i/ps in the text fields....the text fields getting disappeared and also becoming editable...though the data they have already given is being populated in the table..I want ..even after pressing ctl+S...the data should be there & non-editable.
View 2 Replies View RelatedSQL & PL/SQL :: Export To Excel Files?
Mar 25, 2013I want to export my oracle table to (Excel) Format . I am using Oracle SQL Developer 3.2. I know option to export table through GUI. But i want to achive through script level or procedure level.(SQL Developer 3.2). how to achive this i tried for several method but not get the proper output .
View 4 Replies View RelatedClient Tools :: Import With SQL Developer V 2.1.1.64 And Excel Files
Jun 3, 2011Anyway, I do not have much experience with databases (with MS Excel I do) but most of the problems I have been able to resolve by myself.I am using a TNS database.
I want to import data from SAP to the database, but we are having some problems with the connection and so on.Anyway, the only way to get the data into the database is to key them in manually or to import them.I have been using the import function (I had a lot of trouble with date formats) and it worked:I selected the "Import Data", the corresponsing file and then have been able to see an extract of the data. It worked and I have been able to import data from an Excel file to the database.
But an error occured: Some lines have not been copied.So I wanted to reimport them.But from this point of time I have not been able to open any Excel file anymore...When I select the file no extract/preview is given anymore and the file seems to be empty.I cannot select tabs of the Excel file or anything like this.
I restarted the computer, established a new connection to the database and even reinstalled my client.It seems that one setting has changed.I am still able to import the data from *.csv files, but this is not as comfortable that using Excel.
Server Utilities :: Loading Multiple Excel Files To Different Tables
Mar 29, 2012I have a bunch of data in 50 excel files. I need to load all these 50 files into 50 different tables. I would like to do this in one script. I went through the forum to get this information, people suggested create a shell script etc or list the sqlldr command multiple times etc.
provide some clarity on this as to what's the best approach.If it is through shell scripting provide the shell script and instructions to execute it. Iam new to shell scripting.
Forms :: Oracle Builder Object Navigator Reports
Nov 16, 2011I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:
- Forms - MODULE - Reports
I want to know what is the purpose of REPORT section in the Forms Builder.
Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database
Apr 12, 2013I 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.
Forms :: Oracle 9i To Excel
Jul 20, 2005I have been using F60util.pll to convert a form contents directly. But in Forms 9i , this library is giving an error. Which alternative should i use for F60util.PLL.
View 4 Replies View RelatedForms :: Get And Set Hyperlink In Excel From Oracle
Nov 7, 2012In my form i am uploading one excel file Input.xls which has inventory detail. in this file on column is Hyperlinked , when i click on it opens a linked file.
From this file i am generating an Output.xls file which shows links too. How can i get that link and set it to Output.xls file. More in my Input.xls file some rows are colored with grey color which shows detail of diamond piece which are on hold.
Forms :: How To Generate Excel In Oracle 11g
May 4, 2012I had a form in oracle 6i with which I can generate an excel sheet when clicked a button(by using ole2 built in)...this form I have converted to oracle forms 11g and replaced the ole2 with client_ole2 and added webutil library...but the excel is not generated as in 6i.
View 1 Replies View RelatedForms :: How To Integrate Excel With Oracle
Mar 2, 2010How to integrate excel with oracle forms ? that it looks like a detail block. If i give 20 in a test item if i click on a button it should display 20 records in a from 10g that records look like excel records .
View 4 Replies View RelatedForms :: Quit Excel From Oracle 10.1.20.2
Jan 22, 2013I am using Oracle forms 10.1.20.2 and Excel 2007.
I have written the following code to Quit Excel But This removes Excel from the desktop but the application still runs. If you view the task manager you see all the excel application there taking up all the recourse.
ole2.release_obj(worksheet1);
ole2.invoke (workbooks1, 'Close');
OLE2.release_obj(Workbook1 );
OLE2.release_obj(Workbooks1 );
ole2.invoke (application, 'Quit');
OLE2.release_obj(application );
SYS.DBMS_SESSION.free_unused_user_memory;
Forms :: Exit Without Saving?
Dec 5, 2010I have created one master detail form where on master i have one field with name status and if the status is changed to A it will prompt me to another detail block where i will fill the details and in case after i entered the details and then i decide it not to save and come back to main form without saving...how i can do it . I used go_blok In detail to go to master it goes to master but when i am saving the master the details get saved along with it.I dont want to save the detail and go to master block.
View 1 Replies View RelatedForms :: Import Data From Excel To Oracle?
Jun 21, 2013I have designed a form to import data from an excel worksheet into an Oracle Form and It works pretty fine.
I use either Ole2.get_char_property or Ole2.get_num_property depending to the property of the column to read data but there are some columns used by both property which means that database is designed as VARCHAR2. The user can maintain either a numeric or characteristic data there. So I am looking for a solution to be able to make the program more flexible that he can read the property of the cell in excel file and decide what to use between Ole2.get_char_property and Ole2.get_num_property to read from excel file properly.
solve the problem regarding reading from Varchar2 columns.
Forms :: How To Import Excel Sheet To Oracle
Sep 18, 2004How To import data through forms from excel.I have an excel sheet and i have to import these sheet to oracle.but through forms how should i do.
View -1 Replies View RelatedForms :: How To Implement MS Excel SUM IF Function In Oracle
Dec 24, 2010I am trying to translate some input data given in MS Excel into Oracle Forms. The Excel sheet consists of usage of the SUMIF() to calculate the values. I am struggling to implement this in Oracle Forms.
I am attaching a screenshot with some sample data set to explain my problem in detail.
Forms :: Saving Form To View On Web
Jan 26, 2010i have developed a form in 9i. can i view the fmx file on web. or tell me the extenstion what name of form should i use to save the form to view on the web.
View 5 Replies View RelatedForms :: Saving Of Multiple Records At One Go
May 17, 2011My query is: I have created a master-child forms on one canvas. In a child form i have to enter multiple records, but after entering every record its prompting me to save it. I want to avoid it and save the entire thing once all my records are entered.
View 4 Replies View RelatedForms :: BLOB Image Is Not Saving?
Nov 12, 2011I am failed to saved image in the table via forms. (Although i have successfully updated the table with a procedure at PL/SQL level).
Here is what i have done.
1) Table created
create table prod
(pcode number,
image blob);
2) Made a form with guidence present at orafaq
3) It reads and saves image BUT enter/execute query does not show the image
4) even the following code gives me 0
select dbms_lob.getlength(image) from prod
Saving Email In Oracle DB
Aug 23, 2011if it is possible to save an email send from an ORACLE pl-sql packages in the Oracle database it self? The email is in my case created and send directly using the oracle utl_smtp-package.
I have no problems with attaching doc's and so on in this mail. But i simply cannot find a way to save, the email i'm sending in the Oracle-database. The purpose of saving the email in the DB is that i want to be able to reopen an send email, to se exactly what was send.
Oracle Forms 10g Insert Pie Chart In Excel Sheet?
Mar 9, 2012I have been requested to create an excel sheet report in my Forms application (10.1.2.0.2) with data grouped in a pie chart, something like the attached pic (if you cant open go to this link: [URL]
I'm able to create the excel sheet by using OLE2 tool, but I dont know how to insert my pie chart from code.
Attached File(s)
piechart.jpg ( 251.88K )
Number of downloads: 1
Forms :: Use Excel Formulas In Oracle Database / Report
Jul 21, 2010i want to ask that is there any way to use the excel formulas on oracle forms, reports and database level. for example if we want to use IRR formula of excel to use in oracle forms, database and report.
View 3 Replies View Related