Home » SQL & PL/SQL » SQL & PL/SQL » from csv to pl/sql array
from csv to pl/sql array [message #187561] Mon, 14 August 2006 08:06 Go to next message
tom01
Messages: 29
Registered: July 2006
Junior Member
Hello:)

My OAE application has to upload data from csv file to table in database. My idea to do that is:

1. Upload file to htmldb_application_files
2. Copy file contents to pl/sql array.
3. Copy data from pl/sql array to table in database.

Can anybody help me with point #2 and #3???

Thanks!!
Re: from csv to pl/sql array [message #187588 is a reply to message #187561] Mon, 14 August 2006 10:16 Go to previous messageGo to next message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
You may consider External Tables also.
Re: from csv to pl/sql array [message #187592 is a reply to message #187588] Mon, 14 August 2006 10:22 Go to previous messageGo to next message
tom01
Messages: 29
Registered: July 2006
Junior Member
Yes, I know - using external tables would be the best (the easiest). BUT unfortunately I don't have priviliges to create directory on server so I cannot use external tables:(
That is why I have to use pl/sql tables.
Can you help me?
Any other idea?
Re: from csv to pl/sql array [message #187647 is a reply to message #187561] Mon, 14 August 2006 16:01 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Use sql*loader, it is loaded onto every machine when the client is loaded. See the following link for instructions.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160
Re: from csv to pl/sql array [message #187812 is a reply to message #187647] Tue, 15 August 2006 15:36 Go to previous message
tom01
Messages: 29
Registered: July 2006
Junior Member
Thanks Bill!

The link you gave me seems to be really helpful! I will go through it and try to find a solution for my application.

One more question:
SQL*Loader is always installed where database is stored? Or it is necessary to install SQL*Loader always when my OAE application migrate to new environment?

Best regards
Tom
Previous Topic: ORA-03120 ORA-03120 two-task conversion routine: integer overflow
Next Topic: parsing blob_content
Goto Forum:
  


Current Time: Fri Dec 09 05:53:11 CST 2016

Total time taken to generate the page: 0.26372 seconds