| Upload csv to DB table using SQL loader [message #502320] |
Tue, 05 April 2011 17:49  |
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 #504960 is a reply to message #502320] |
Thu, 28 April 2011 09:22  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
