Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Upload csv to DB table using SQL loader
Upload csv to DB table using SQL loader [message #502320] Tue, 05 April 2011 17:49 Go to next message
coolguy01
Messages: 64
Registered: August 2006
Member
Hi,
I was wondering if we could upload the data in a csv to a DB table using SQL loader instead of the APEX loader. Is there a way i could invoke the SQL loader on a button click from the APEX page. If its possible could anybody let me know how this could be done?
Re: Upload csv to DB table using SQL loader [message #502321 is a reply to message #502320] Tue, 05 April 2011 17:58 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
consider utilizing EXTERNAL TABLE
Re: Upload csv to DB table using SQL loader [message #502327 is a reply to message #502321] Tue, 05 April 2011 22:06 Go to previous messageGo to next message
coolguy01
Messages: 64
Registered: August 2006
Member
I need to use SQL loader as per the requirements .. is it possible to do so?
Re: Upload csv to DB table using SQL loader [message #504960 is a reply to message #502320] Thu, 28 April 2011 09:22 Go to previous message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Hi, Coolguy

Not Possible. Because Apex users are web clients. To invoke SQL LOADER you must be logged into the server or you have to install Oracle 10g client in you PC and then connect to the server. web clients do not have access to the server directly. Apex users connect through HTTP Server and connects to the database with APEX_PUBLIC_USER, which has very limited privilege to the database.


Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka
Bangladesh

[Updated on: Thu, 28 April 2011 09:23]

Report message to a moderator

Previous Topic: Attribute Dictionary - Apply Changes to Multiple Pages
Next Topic: Calling a URL through a trigger
Goto Forum:
  


Current Time: Fri Aug 07 14:02:08 CDT 2020