Help Required:How Upload Excel file Into Oracle Table Using PLSQL Procedure

Advertisement

Please Help , Urgent Help Needed.
Requirement is to Upload Excel file Into Oracle Table Using PLSQL Procedure/Package.
Case's are :
1. Excel File is On Users/ Client PC.
2. Application is on Remote Server(Oracle Forms D2k).
3. User Is Using Application Using Terminal Server LogIn.
4. So If User Will Use to GET_FILE_NAME() function of D2K to Get Excel File , D2k Will Try to pick File from That Remote Server(Bcs User Logind from Terminal Server Option).
5. Cannot Use Util_File Package Or Oracle Directory to Place That File on Server.
6. we are Using Oracle 8.7
So Need Some PL/SQL Package or Fuction/ Procedure to Upload Excel file on User's Pc to Oracle Table.
Please Guide me wd some Code. or with Some Pl/SQL Package, or With SOme Hint. Or any Link ....
Jus help to Sort This Issue ........
you can also write me on :
[email protected], [email protected]

Advertisement

TEXT_IO is a PL/SQL package available only in Forms (you'll want to post in the Forms forum for more information). It is not available in a stored procedure in the database (where the equivalent package is UTL_FILE).
If the Terminal Server machine and the database machine do not have access to the file system on the client machine, no application running on either machine will have access to the file. Barring exceptional setups (like the FTP server on the client machine), your applications are not going to have more access to the client machine than the operating system does.
If you map the client drives from the Terminal Server box, there is the potential for your Forms application to access those files. If you want the files to be accessible to a stored procedure in the database, you'll need to move the files somewhere the database can access them.
Justin

October 11, 2015

Help Required:How Upload Excel file Into Oracle Table Using PLSQL Procedure

Please Help , Urgent Help Needed. Requirement is to Upload Excel file Into Oracle Table Using PLSQL Procedure/Package. Case's are : 1. Excel File is On Users/ Client PC. 2. Application is on Remote Server(Oracle Forms D2k). 3. User Is Using Applicati

Uploading excel file into internal table

Hi, Any function module is there to upload an excel file into internal table in CRM 7.0 system? Thanks.Hi Ginger, If u have access to ECC R/3 make use FM 'TEXT_CONVERT_XLS_TO_SAP' source code which is existing to convert to Excel to Internal table. 

Uploading excel file into internal table with field length more than 255

I am trying to upload the data from an excel file through function module 'TEXT_CONVERT_XLS_TO_SAP'. I have tested by changing the field type from string, and char2000. But it is accepting only 255 chars from the cell content. How to get the total co

Upload excel file to internal table in web dynpro program

Hi friend's In web dynpro program how to upload excel file into  internal table and finally data will be save Y table.hi, See the properties of File Upload UI element.. Link: [http://help.sap.com/saphelp_nw70ehp1/helpdata/en/48/732f0510d83ff6e1000000

Upload excel data into Internal table

Hi, I'm trying to upload excel data into internal table, well the excel file layout will be different on each run of the report. Excel file will have 60 columns and 500 record limit. I can upload the excel data using 'ALSM_EXCEL_TO_INTERNAL_TABLE' an

Upload a file into Oracle database without using a temp file in the server.

Hello. I need to upload a file into a Oracle database, but I have not permission to write a temp file in the aplication server. Because of this, I can't use a MultipartRequest object. Does anybody know how to do this? Thanks everybody for your help.Y

How do I upload XML files into sap table?

Dear all, I found some methods that upload xml into SAP, but there doesn’t work under 4.6c. Can someone tell me how to upload XML files into sap under 4.6c? THX!hi, You can convert XML to abap using transformations. Simple transformations is a propri

How to transfer data from excel files into z-tables

Please help me with a code which transfers data from excel file to z-table. Thanks in advance ShuvirHi Daniel, Export Data Purpose Use this procedure to export SAP data to a local file such as Microsoft Excel. Menu Path Use the following menu path to

Upload .txt file into Database Table

Hi, I was wondering if someone could please point me in the right direction. I've been looking around the forum but can't find anything to help me achieve the following. I would like to be able to upload a .txt file using a webpage. Then store the in

Map Excel worksheet into Oracle tables repository

I am new to VB2005. I am working on VB code that can map(read) any table from excel worksheet and load it into Oracle table. Oracle table that I have are: 1)META_OBJECTTYPES(OBJECTTYPEID pk,OBJECTTYPENAME,OBJECTTYPEDESC, OBJECTMETATYPE,OBJECTDOMAIN).

How to load a XML file into a table using PL/SQL

Hi Guru, I have a requirement, that i have to create a procedure or a package in PL/SQL to load  XML file into a table. How we can achive this.ODI_NewUser wrote: Hi Guru, I have a requirement, that i have to create a procedure or a package in PL/SQL

Issue while uploading .TIFF file into Standard text using RSTXLDMC

Hi All, We are facing issues while uploading .TIFF file into standard text through program RSTXLDMC. Getting the following error. TIFF format error: No baseline TIFF 6.0 file. The image is a colored one. Please provide me solution if anyone has worke

Map FLAT file to oracle table using 9.04 version - PLS HELP!!!!

Hello all I am having a problem with mapping a flat file to oracle table. The validation is successful, when I go to Project/Deployment manager. Try to deploy the mapping itself and the target table. It said succesful, and the last step is another "D

How to upload above20000 records csv files into oracle table,Oracle APEX3.2

Can any one help me how to CSV upload more than 20,000 records using APEX 3.2 upload process.i am using regular upload process using BOLB file SELECT blob_content,id,filename into v_blob_data,v_file_id,v_file_name FROM apex_application_files WHERE la

Insert excel file into a table

Hi all, I have a excel file with a lot of records. I want to insert all this records into a table without using a insert statement for every record. Can any one help me with this? ekasIf you have a .csv file then use an EXTERNAL TABLE so you can read

How to  load data into user tables using DIAPIs?

Hi, I have created an user table using UserTablesMD object. But I don't have know how to load data into this user table. I guess I have to use UserTable object for that. But I still don't know how to put some data in particular column. Can somebody p

Uploading CSV file to DB table using APEX

HI, Can anyone guide me how to upload a .csv file to a DB table. THANKS IN ADVANCEuser12550902 wrote: as i got some information from the otn..i got a pl/sql code which is used in the process. i used it in browse item .selecting file in the client dis

How to upload excel file in application server??

Hi, How to upload an excel file into internal table in background mode from application server? ThanksHi vipin, check this it may help you... hope below links helps you Export the report list to Excel Sheet http://www.sapdevelopment.co.uk/file/file_u

Unable to load excel sheet into oracle

Can somebody help me... I just want to load data records from MS Excel spreadsheet into Oracle table without converting that MS Excel file, my ENV: Linux (centos 5.4 + Oracle EE 11gR2) here what I did: -ODBC-Conf on MS create a system DSN 'odbc_excel

Uploading Excel file  using 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Hi, I am uploading excel file into an internal table using 'ALSM_EXCEL_TO_INTERNAL_TABLE' FM. but I'm getting a popup with the message 'There is a large amount of the information on the clipboard. Do you want to be able to paste this information into