Home » Developer & Programmer » Forms » uploading the file in database table (oracle forms)
uploading the file in database table [message #293864] Tue, 15 January 2008 06:15 Go to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Hello,
User will select the file in CSV format through oracle form and this file should be sent to server and read the file and load the data into table.
Howcan we do this? user dont want to use FTP utilities.
Can we use BLOB datatypes for this?
HOW??

Report message to a moderator

Re: uploading the file in database table [message #293874 is a reply to message #293864] Tue, 15 January 2008 07:05 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is SQL*Loader (or even external tables feature) an option to your end-user?

Report message to a moderator

Re: uploading the file in database table [message #293977 is a reply to message #293864] Tue, 15 January 2008 17:30 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
A CSV file can be read using 'text_io' or 'utl_file' and you can then process the information using the rules associated with data in CSV format.

What version of Forms and database are you using?

David

Report message to a moderator

Re: uploading the file in database table [message #294056 is a reply to message #293864] Wed, 16 January 2008 05:02 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
correct. UTL_FILE could be an option.
But for that you need to have file on server. But in my case file is on client and we will have to transfer the file first and then the task is easy.
I was planning to use DBMS_LOB. i will upload the file in table in the form of BLOB. and will read the file.
How is this option?

Do you have any script which will read the BLOB using dbms_blob?

Report message to a moderator

Re: uploading the file in database table [message #294057 is a reply to message #293864] Wed, 16 January 2008 05:04 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
we can use sql*loader, and lot other utilities but only when file is on server. file is not on server. its on client. now problem is how to transfer the file to server.

Thanks a lot for your reply....Smile

Report message to a moderator

Re: uploading the file in database table [message #294157 is a reply to message #294057] Wed, 16 January 2008 11:09 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
You can try the pl/sql webtool kit....

read this link:

http://download-uk.oracle.com/docs/cd/B14099_19/web.1012/b14010/concept.htm#i1005985

Hope it provides some clue....

Report message to a moderator

Re: uploading the file in database table [message #294209 is a reply to message #294157] Wed, 16 January 2008 17:16 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I have no idea what you were trying to show using that link.

@parag_narkhede,

Search this forum for 'webutil' and 'web_util'. Use its 'client' facilities to open a 'Windows Explorer' panel in the browser, point to your local file, then use the 'file read' utility to process the input file.

David

Report message to a moderator

Re: uploading the file in database table [message #294213 is a reply to message #294209] Wed, 16 January 2008 18:42 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
djmartin - Its easy to make out from the link ----- search for the file upload within that page... maybe its useful for parag, if not for others...

Parag - if you search for file upload, there is a method using DAD you can upload files from the client machine to the db.... I have done similar to this, but using the forms javabean implementation, its pain and has limitations... if the link is useful fine else ignore it.....

Report message to a moderator

Re: uploading the file in database table [message #294251 is a reply to message #293864] Wed, 16 January 2008 23:49 Go to previous message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
I think generally people use JAVA implementaion for this purpose. I have got a form which has already these features applied. I will definitly share that with you... Till then, again , thanks for your help. and keep helping... Cool

Report message to a moderator

Previous Topic: reading com port data
Next Topic: update trigger error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 00:14:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.