Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database

Apr 12, 2013

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.

View 1 Replies


ADVERTISEMENT

Oracle Forms 10g Insert Pie Chart In Excel Sheet?

Mar 9, 2012

I 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

View 1 Replies View Related

Forms :: Use Excel Formulas In Oracle Database / Report

Jul 21, 2010

i 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

Forms :: How To Connect Excel With Oracle Database Via 10g Login Screen

Jul 20, 2010

In 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.

View 3 Replies View Related

Forms :: INSERT Record - Update Columns Of Table

May 31, 2010

I would like to UPDATE the columns p1 and p2 of my table student (studentid:pk,name,p1,p2,...) for a given studentid.and I have a when-button-pressed trigger with this

UPDATE student
SET student.p1=:validation.proj1,
student.p2=:validation.proj2
where UPPER(student.studentid)=UPPER(:validation.studentid);commit_form;

when I run my form with a correct studentid, I got this error: FRM-40508: ORACLE error: UNABLE to INSERT record

but it is cworking correctly in sqlplus; and I have all priveligies.

View 4 Replies View Related

Forms :: Insert Record Into Lov Through Oracle Custom Forms?

Oct 8, 2013

I 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

View 12 Replies View Related

Forms :: Oracle 9i To Excel

Jul 20, 2005

I 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 Related

Forms :: Get And Set Hyperlink In Excel From Oracle

Nov 7, 2012

In 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.

View 1 Replies View Related

Forms :: How To Generate Excel In Oracle 11g

May 4, 2012

I 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 Related

Forms :: How To Integrate Excel With Oracle

Mar 2, 2010

How 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 Related

Forms :: Quit Excel From Oracle 10.1.20.2

Jan 22, 2013

I 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;

View 5 Replies View Related

Forms :: How To Pass Excel General Value To Database Tables Date Field

Jun 17, 2013

i've following code

declare
i INTEGER:=0;
flag boolean:= FALSE;
vcInsert:='INSERT INTO CRM_DELT_IMPORT (';
if length(i_vcColumn1) > 0 then
flag:=TRUE;

[code]....

i am fetching data from excel all data is of general type, here i am passing value is VTDATE varchar2(100) but actual database column filed is DATE , How can i pass '13-06-13 05:54:33' to database table.

if i put this condition
vcInsert:=vcInsert|| ','||''''||i_ldata(i).to_char(VTDATE,'DD-MM-RR HH12:MI:SS')
i get the error
to_char must be declare.

if i remove this line

i am getting this error ORA-01843: not a valid month

View 8 Replies View Related

Forms :: Import Data From Excel To Oracle?

Jun 21, 2013

I 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.

View 1 Replies View Related

Forms :: How To Import Excel Sheet To Oracle

Sep 18, 2004

How 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 Related

Forms :: How To Implement MS Excel SUM IF Function In Oracle

Dec 24, 2010

I 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.

View 6 Replies View Related

Forms :: Insert Into Database

Jul 21, 2010

I have a form and 2 blocks(master-detail) and try to add a new record when I press "insert record" button from toolbar. But there occurs a problem. If I don't write 'CLEAR_FORM' just after calling "button_proc" procedure, record is not added into database.I couldn't understand why.

View 8 Replies View Related

Forms :: Saving Excel Files As Object In Oracle?

Feb 13, 2012

How can we save Excel file as an objectin oracle. Like we can store image file.

View 1 Replies View Related

Forms :: Data Load From Excel To Oracle 10g Through 10g Client

Aug 13, 2011

how to load data from excel sheet to oracle 10g form from client.

View 1 Replies View Related

Forms :: Download / Upload To Excel Through 6i In Oracle Apps

Nov 24, 2010

download / upload data from / to database through oracle forms 6i which is deployed in oracle apps 11i.I am using DDE/OLE2 but it is downloading if form is stand alone but when i post this form in my UNIX server, it is not downloading.

Oracle apps is in UNIX and i want excel to be in client (windows).what procedure to be used.

View 1 Replies View Related

Forms :: Open Word Document / Excel / PDF From Oracle?

Mar 25, 2008

I would like to open a word document /excel sheet /pdf from oracle forms.

View 20 Replies View Related

Forms :: Import Excel By Column Mapping Using Oracle 6i

May 25, 2013

I want to imopert excel data by coloumn mapping to oracle table using forms 6i". for this I've created a form which is having following details.

1. path, file name text field and button called browse. when the form load. click on browse botton, and user will be asked to go to specific drive and select the excel file. The file path is stored in path text field and file name is displayed on file name text field.

2. After doing this I've porvide a button called column. after selecting the file click on column button. Once the button is pressed all column heading of the selected excel file get displayed on the text fields which i've provide on the form.

3. In frot of each column headig field I've provide list box which contains database table column heading. Now user have to select table column according to his excel column. (i.e I am asking user to map his excel column with oracle table column.)

4. Once the maping from user is done, I've provide button called process. once the button is pressed all the data from excel is to get insert in to database colmum.

what i've achive -
- User is able to select file path and file name get displayed.
- Columns heding of excel get displayed on the form.
problem area
-In the process button code column heading get change dynamically but records i.e actual data does not.
-I am able to insert records into table, but only when excel column heading sequence is same as database table column.

excel column = table column
-----------------------------------------------------------------
route = route
date = del_date
time = del_time
id = tran_id

In above situation record get insert into table. But when only excel column sequence change that time data is not inserted into table. If required i can upload my form and sample excel sheet also provide table script.

View 4 Replies View Related

Forms :: Open Word Document / Excel And PDF From Oracle?

Apr 29, 2010

does the path of office on the server or on the client PC?

View 1 Replies View Related

Forms :: Oracle Code To Export Data To Excel

Jan 8, 2010

I do the codding procedur in oracle form code to export data to Excel.But when i run the form and call that procedure. The data is come to excel, but it's autometic create a new sheet(as "Sheet4").

The problem is.. How can specify the Sheetname or fix it as "Sheet1"?

---Following it's my code

PROCEDURE Export2EXCEL_FILE(P_MAXCOL_NUM NUMBER) IS
cursor dtl is select * from SG_TMP_REPORT_RESULT
where SOURCE_ID = :BLK_CTRL.NB_SOURCEID
ORDER BY COLTYPE;
row_num number;
col_num number;
cell_val number;

[code]....

View 13 Replies View Related

Forms :: Batch Program Retrieve Data From Oracle To Excel

Jul 5, 2011

I'm developing a new batch program retrieve data from oracle to excel.Normally i insert those data into single sheet. Is it possible if I want do this into multiple sheet.

Eg: I need to insert data base on branch category. different sheet for different branch but still in a single workbook?

View 2 Replies View Related

Forms :: Provide Excel Sheet With Column Header Only In Oracle 6i

Jun 6, 2013

I want to provide excel sheet with column header only to user, with the push button of oracle forms.(i.e user suppose to get the excel sheet when he press the button on the form).

View 3 Replies View Related

Forms :: Oracle Report Excel Output Repeated Header In Each Line?

Nov 24, 2011

After running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!

View 4 Replies View Related

Forms :: Export Forms Data Into Excel Sheet - Client-ole2 Not Working?

May 28, 2010

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

View 7 Replies View Related

Server Utilities :: Insert Excel Spreadsheet Into Oracle

Mar 25, 2010

I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work.

Is there a special formatting I need to do with excel(I have tried just about every date format in excel and tried matching the date style to the one in oracle and tried doing the opposite)? I have tried every step that I can possibly think of.

whenever I format the Date in the Oracle loader it gives me the Success message for the dates but still fails to load? ive also tried many format with the oracle loader.

View 5 Replies View Related

Forms :: To Insert Image In Database Using Browse Button

Mar 10, 2011

i want to insert a image in database using form(using browse button), when i use commit_form,all text data are saved but image file is not save & form has also not given any error.

View 5 Replies View Related

Forms :: Insert DATA In Database In Uppercase Format

Mar 19, 2013

I have a datablock based , I used commit_form(); to insert data in my DB .But,I want to insert data into my DB on uppercase format!!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved