| Import excel file in oracle [message #668704] |
Mon, 12 March 2018 01:13  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
