Home » SQL & PL/SQL » SQL & PL/SQL » Need Help in adding photo (Oracle 9i, Windows)
Need Help in adding photo [message #333953] Tue, 15 July 2008 00:44 Go to next message
sai.baranidharan
Messages: 4
Registered: July 2008
Location: Chennai
Junior Member
I need to insert photo as a BFILE type into my database table. The inserted photo needs to be stored in a folder automatically.

I have a field 'joining date' in my database. The photo inserted should be stored in the folder whose name is the year of joining. The folder should be automatically created.

Also, the file name should contain the number of the row that is being inserted.

Please help me in this issue. I need to submit this in 5 days.
Re: Need Help in adding photo [message #333955 is a reply to message #333953] Tue, 15 July 2008 00:49 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above
Re: Need Help in adding photo [message #333959 is a reply to message #333953] Tue, 15 July 2008 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the file name should contain the number of the row that is being inserted

What does this mean? Which file name? Photo file one? How many rows has a photo?

Regards
Michel
Re: Need Help in adding photo [message #334406 is a reply to message #333953] Wed, 16 July 2008 06:58 Go to previous messageGo to next message
sai.baranidharan
Messages: 4
Registered: July 2008
Location: Chennai
Junior Member
I am doing my Masters degree and I need to submit my project as part of my curriculum.

I am using Java as front end and Oracle 9i as back end to develop a desktop application on College Management System.

In this application, I need to add the details of students who had joined into the institution.

The database table contains fields like 'JOINING DATE','ROLLNO'(and some more fields, which I am not mentioning here)

What I need is this:

1. I need to insert a photo into the database. The photo needs to be stored into a folder. The folder's name should be the 'year of joining'(This can be retrieved from the field 'JOINING DATE'). This should not be done manually. It should be automatically created when the photo is inserted.

2. The file name of the photo inserted into the folder/table, should be the student's roll number.

I think I am clear. If you need further details, please post it. I would reply to you as soon as possible.

As I am learning Oracle and doing it, I am seeking the help of some professionals in this forum. Please do not mistake me or neglect my post.

thanks a lot.

Re: Need Help in adding photo [message #334410 is a reply to message #334406] Wed, 16 July 2008 07:03 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Oracle does not manage directories or files, this is an issue for your Java application.

2. Idem.

A simple select allows you to retrieve the data you want, the other points (naming) is for your Java application, then you can reference the photo in your Oracle table using a BFILE field which is just a "pointer" to the OS photo file.

Regards
Michel
Previous Topic: parameters of sub functions
Next Topic: Removing ',' in values?
Goto Forum:
  


Current Time: Mon Dec 05 14:40:22 CST 2016

Total time taken to generate the page: 0.15612 seconds