Home » Developer & Programmer » Forms » Import excel file in oracle
Import excel file in oracle [message #668704] Mon, 12 March 2018 01:13 Go to next message
malu
Messages: 14
Registered: December 2017
Junior Member
Hello All,

I have a requirement to import data from excel to oracle Db.
i have installed XE 11g in my local machine .
I got PL SQL package as_read_xlsx written by Anton Scheffer . compiled the package .
created directory and placed an excel test.xlsx in that folder with two records
and used below query to get data.

SELECT *
FROM TABLE(as_read_xlsx.read (
as_read_xlsx.file2blob ('DOC', 'test.xlsx')))

It is not giving any error but not showing any records .
Anyone has any idea why no records are fetching .
is there any specific way to do .

Regards,
Malu
Re: Import excel file in oracle [message #668706 is a reply to message #668704] Mon, 12 March 2018 01:41 Go to previous message
malu
Messages: 14
Registered: December 2017
Junior Member
Dear all ,
Its working ..
it was due to i didnt give grant to the dir .
Sorry for troubling ..Smile
Regards,
Malu
Previous Topic: FRM-40737 --- Occured for a form
Next Topic: Ora-302000
Goto Forum:
  


Current Time: Thu Mar 28 09:36:02 CDT 2024