Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

Can a Oracle external table go to a client machine and grab data saved in a excel csv file?

I need to develop a pl/sql stored procedure to load a csv file from a client side to a external table on the server side. I think I need to develop this procedure since I think Oracle external table which must be placed in the server side canot go directly goes to user machine and grab data from a csv file saved in user's directory. I  don't know how to go to develop such a procedure and need help started. Thanks
0
lmymusic2000
Asked:
lmymusic2000
  • 2
  • 2
1 Solution
 
sdstuberCommented:
yes/no - depends

If the server has access to the client machine (possibly samba shares or nfs mounts)
and
if the remote filesystems are accessible by Oracle
and
if the pl/sql procedure has access to that directory (via utl_file_dir or directory object) then yes

if any of those are not true, then no



0
 
lmymusic2000Author Commented:
If the server has no access to the client machine then how would I go to develop a procedure to load a csv file from the client side to a external table in the server side? I know that it has to do with UTL FILE package but I do not know exactly how to  code to achieve this? Any help would be appreciated.
0
 
sdstuberCommented:
utl_file won't help either,  same restrictions as above.

you will need to have some client side tool that will load a clob/blob directly into the database or ftp the file to the server.
0
 
lmymusic2000Author Commented:
In my case this user can access to Portal through which I can develop a pl/sql procedure on the back side that connects user by a form for them to upload their cvs files to the server but I do not have enough knowledge to do this and I am not sure it is possible to do this like you mention above. Another approach to this problem is upload this cvs file as a blob object to a table.  I know how to write a procedure for user to upload their file by blob object to a table but I don't know how to break down this blob into individual data. I need help on converting this blob file to individual data if you know of a way it can possible, I appreciated very much.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now