Forms :: Import CSV Directly Into D2kwutil / Reading From File?
Jan 29, 2008
I know that this topic in not new, but maybe my case is a bit different than common.My form has multi-record block (4 columns) in which i want to upload CSV file.
The form will have "Browse..." button to piont CSV file (on local users disc, not where Forms server resides) after pointing the CSV file, user will press UPLOAD button which will import CSV data into block. After that data is visible in block. But whole form must not be refreshed.
I'm studying about UTL_FILE package, but it seems it allows manipulating files on server not local user's machines. Do Forms have such "Browse... -> UPLOAD" possibility or I need to learn Java and create Java funcionality inside Forms?
Or it is impossible to load data directly into form? (I have to use SQLoader and load data into temp table then into block on form????)
View 7 Replies
ADVERTISEMENT
Feb 25, 2012
I'm trying to create an upload button in oracle forms 6i using D2KWUTIL win_api_dialog.open_file function. This works fine in Windows XP (32-bit), but in Windows 7(32-bit) I keep receiving "FRM-40734: Internal Error: PL/SQL error occurred" error.
I traced the source of the error to an exception called "WIN_API.NOT_AVAILABLE" captured in a function called "ChooseFile" that are used by the "Open_File" function and reside on the same package.
Does D2KWUTIL even work with Windows 7?
View 1 Replies
View Related
Mar 8, 2011
I need to read data from text file(located on application or db server or on some other server, however path is known to me.) and then append some data in it.
Data will be read and written on daily basis so i want to clear all data on date change.
View 3 Replies
View Related
Oct 10, 2011
I just trying to import some informations from excel to Oracle using OLE2 over Oracle Forms 6i, but It´s very slow when I have import under then 10k lines. anything to optimize that ? Follow the code used...
application OLE2.Obj_Type;
workbooks OLE2.Obj_Type;
workbook OLE2.Obj_Type;
[Code]....
View 2 Replies
View Related
Oct 25, 2013
I have a Excel File which contains some columns and rows, i need to load that excel into a form and import that form data to Database Table, using DDE Method.
In simple i say; Just to read the excel and load into a form, which can be imported into a table later.
How to achieve this? only dde method.
View 10 Replies
View Related
May 31, 2011
I tried to import a dump in 11g that was taken in oracle 9i. The import started but it hangs after some time. Exactly say it check only the character set of the DB's then it hangs. let me know if there are any specific procedures to import a dump from 9i to 11g directly.
View 8 Replies
View Related
Jun 12, 2012
Is there any way that dumpfile can be created directly on the target rather than on the source and copying that dumpfile to target using datapump. I want to do full database export.
View 8 Replies
View Related
Jul 27, 2012
How to create directly pdf file in reports 6i and what type of parameter use and how to use?
View 3 Replies
View Related
Jul 16, 2012
I am using jasper integration package ..from www.opal-consulting.de using apex 4 and i Am currently able to generate pdf invoice..using jasper and store in a database.. table.
I need to generate the pdf invoice in the background ..without displaying in my screen..Without downloading on my machine..And store directly into the database table..
Below is my existing part of code..
DECLARE
l_blob BLOB;
l_mime_type VARCHAR2 (100);
l_blob2 BLOB;
l_mime_type2 VARCHAR2 (100);
mport varchar2(200);
[code]....
View 9 Replies
View Related
Dec 1, 2011
I am looking for a code/script to read values from excel file and perform PLSQL script.
Now i have the PLSQL script to generate report which takes two value which i have to change all the time to generate new report .All i wanna do create a script to read from a excel file and perform the other script.
I have been searching from a long time and only found UTL_file Package which use CREATE OR REPLACE FUNCTION and create some virtual table.
The problem is i don't have create authorization in database so i m not able to use UTL_File command . Is there any simple way to read value from excel file?
View 16 Replies
View Related
Jul 8, 2013
I'm trying to utilize the utl file to read a txt file and import the data into a table in Oracle. I've read in various forums and have researched a lot on oracle documentation site and on the internet but can not find the answer to the problem.
The source follows:
Set serveroutput on
DECLARE
arquivo_ler UTL_File.File_Type;
Linha Varchar2 (1000);
BEGIN
arquivo_ler: UTL_FILE.FOPEN = ('INTRANET_LOAD', 'carga_intranet.txt', 'R', 32767);
Loop
UTL_File.Get_Line (arquivo_ler, Linha);
dbms_output.put_line (Linha);
End Loop;
UTL_File.Fclose (arquivo_ler);
DBMS_OUTPUT.PUT_LINE ('File processed with sucesso.');
END;
/
The errors:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 633
ORA-29283: invalid file operation
ORA-06512: at line 5
What has been done:
Created DIRECTORY (INTRANET_LOAD) and given the GRANT read, write to the user
On Linux where Oracle is installed, was given full access to the Oracle user folder: / u01/app/oracle/product/11.2.0/db_1/adp
When writing the query;
SELECT *
FROM ALL_TAB_PRIVS
WHERE table_name = 'INTRANET_LOAD';
The data are returned.
1 FOLLOW INTRANET INTRANET_LOAD SYS READ NO NO
2 FOLLOW INTRANET IN NO WRITE SYS INTRANET_LOAD
View 10 Replies
View Related
Jun 8, 2011
A doc file stored in a database having data type blob. To read this file I have written Following procedure
create or replace procedure XX_read_blobfile1 as
b blob;
c clob;
n number;
begin
SELECT file_data INTO b FROM fnd_lobs WHERE file_id = 322420;
if (b is null) then
[code]......
With the data displaying some boxes before and after data
View 11 Replies
View Related
Jul 3, 2012
working on loading the data from flat file into table and below given is the validation condition given.I checked the UTL_FILE build in package but not able to figure out, how to identify the column header in flat file.
1. Skip the header, if any. The header is the first record, and starts with '000'
2. Skip the trailer, if any. The Trailer is the last record, and starts with '999'
3. Log an error, but continue if a line exceeds 512 characters
4. Log an error, but continue if a line is blank
View 5 Replies
View Related
Jul 1, 2013
I would like to read specific line in the file in the util file.
View 1 Replies
View Related
May 1, 2012
I need a way to ftp file to remote server by reading data from table. I searched a couple of sites which asked me to use Chris xutl_ftp package..but unfortunately the site is no accessible..
Here is the code
CREATE OR REPLACE PACKAGE UTL_FTP
AUTHID CURRENT_USER
AS
/**
* LICENSE: GNU Lesser General Public License (LGPL)
* Copyright (C) 2003-2006 Russ Johnson (john_2885@yahoo.com)
[code].....
View 3 Replies
View Related
May 3, 2011
I want to import text from text file. How i can import in oracle forms ( oracle 9i)
View 7 Replies
View Related
May 17, 2013
During the scheduled backup we observed that, backup got failed. Error is "ORA-01115: IO error reading block from file 11 (block # 118736)
".
unable to rectify it. Below are the part of log file -
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"DW_REP"."DW_MOTOR_CLAIM_INFO_DTLS"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 8976
ORA-24795: Illegal ROLLBACK attempt made
[code]...
This is development server. Dont have RMAN configured.But when we connected to RMAN and issued block recovery, it started process and shows media recovery done. Since no RMAN backup was taken before, what it does here?
C:UsersAdministrator>RMAN
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 17 10:48:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> CONECT target /
connected to target database: MAGMADEV (DBID=2469200049)
[code]...
how to resolve this problem?
View 6 Replies
View Related
Jan 31, 2011
I'm developing now in 11g and i have some reports that i want to send directly to the printer. I been having some troubles and as i searched the web, i saw that for 9i and 10g, this was not possible without using orarrp. But i can't find any info about this for 11g. Is this true that i can only let user print direct using this tool? Plus, is this tool available for linux x64? Can i add the printer to the server and would it work now?
View 2 Replies
View Related
May 29, 2013
I want to print a report to the printer directly. The main issue is that I don't want the user to save the report to prevent reprint of legal Order. Below is my code to produce 'PDF' format.
PROCEDURE
run_report_proc (rep_id report_master.REPORT_ID%type,pl_id ParamList ) IS
repid REPORT_OBJECT;
rep_name report_master.REPORT_NAME%type;
v_rep varchar2(1000);
rep_status varchar2(20);
rep_acc char(1);
[code]....
View 3 Replies
View Related
Jul 2, 2012
How to import data from excel(.xls) file to data base table
I have excel sheet(.xls) data details, I neet to upload details to data base table using procedure
excel sheet is not CSV file, so SQL Loader is not using
any alternative solution for this issue
View 3 Replies
View Related
Feb 11, 2013
I received dmp file , and i want to import only data from that file ?
How can we achieve that in oracle Oracle 11.2.0.3
View 5 Replies
View Related
Feb 16, 2004
how to read the excel data and insert into tables without using SQL loader. i tried using OLE2 package,but i am getting an non-oracle exception. even i tried using CSV format. but i couldn't make it.
View 3 Replies
View Related
May 14, 2010
I have a base table (Table A) block with multiple records displayed. I need to track audits to this underlying table in the following way:
If user updates a field in the block I want the pre-changed record's audit fields to be set and I need to create a copy of the record with the changed values. Basically any changes will result in the record being logically deleted, and a copy record created with the newly changed values.
Tried to implement in the block's pre-update trigger which will call a package to directly update Table A then Insert into Table A, then requery the block. Is there a clean and efficient way to do this?
View 4 Replies
View Related
May 28, 2011
i had import a database dump file & this database has username/password say abc/xyz. my database username/password is system/vinod. after importing i'm unable to login with system/vinod(error:invalid username/password) and one strange thing was happened;a user was created with abc/xyz(username/password). after altering my user only then i'm able to login with my original user.
View 1 Replies
View Related
Dec 14, 2006
I want to load data to a table and from a simple file text, using a Vb.net application which will connect to a oracle 10g , or a SqlServer or a MySql database, depending the params.
When i connect to a SqlServer Database i use the sql command "BULK INSERT CODPOSTAL2 FROM file.txt with( DATAFILETYPE = 'char',FIELDTERMINATOR = ';', ROWTERMINATOR = '
')"m" and it works fine.
With a DB Mysql i use "LOAD DATA INFILE file.txt INTO TABLE CODPOSTAL2 FIELDS TERMINATED BY ';''" and also works.
My problem is with Oracle. I tried the same example as MySql, but it gaves the error "wrong" ou "unknown command". I also tried in Sql*Plus but it seems to not recognised the command "LOAD".
Another thing, i can't use the Oracle Loader, it must be like this.
View 5 Replies
View Related
Jan 10, 2013
I have two columns in excel which i need to import in oracle table , but the problem is one column is of type date , i want the same date format to be maintained in table too.
View 8 Replies
View Related
Nov 12, 2012
How to import *.dmp file Through Oracle SQL Developer (3.2.20.09) ? How to do it ?
View 3 Replies
View Related
Mar 14, 2012
my problem is that whenever i want to import a dump file(oracle 10g) oracle just import 4 tables and then goes into hang state(not responding) i'm using old import method (not datapump).
View 1 Replies
View Related
Jul 27, 2010
I'm trying to import a xls file that I converted into a csv. I have a notes column that has carriage returns in it. This is causing SQL LDR to error out with the following error:
second enclosure string not present
It is only grabbing up until the first carriage return.how I can get it to load?
View 1 Replies
View Related
May 2, 2011
I am trying to import data from a dmp file using the command IMPDP Here is the command :
impdp
USERID= core_edb_20112_ct/local
DIRECTORY=dir_core20112
DUMPFILE=CORE_EDB_20112_CT_20110426.DMP
LOGFILE=log_core02112_1.log
SCHEMAS=core_edb_20112_ct
REMAP_SCHEMA=core_edb_20112_ct:core_edb_20112_ct
PARALLEL=4
METRICS=Y TRANSFORM=OID:N
TRANSFORM=SEGMENT_ATTRIBUTES:N
REMAP_TABLESPACE=C64_EDB_TS:C64_EDB_TS
I am trying to import data in the following user : core_edb_20112_ct/local
This user is already created , using the tablespace named C64_EDB_TS
The dmp file resides in the location dir_core20112 ( e:\oracle)
I am getting the following error while i try to import
Import: Release 11.2.0.1.0 - Production on Mon May 2 12:47:54 2011
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "CORE_EDB_20112_CT"."SYS_IMPORT_FULL_01" failed to load/
unload
ORA-02354: error in exporting/importing data
ORA-02368: the following file is not valid for this load operation
ORA-02369: internal number in header in file e:\oracle\core_edb_20112_ct_20110426.dmp is not valid.
The DMP is copied from a different network location into the local drive where the command is running.
View 1 Replies
View Related
