Home » Developer & Programmer » Forms » Image Path save in database and image name as Design no (developer 6i database 10g window xp)
Image Path save in database and image name as Design no [message #406333] Wed, 03 June 2009 06:50 Go to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Hellow all


I create a simple table for image
CREATE TABLE image_table (
  Design_no varchar2(10),
  filename VARCHAR2(255)    PRIMARY KEY,
  image    LONG RAW); 


Then i create simple block of image_table

its show me in this website
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:239814548726

My question is i don't want to give my form path always
i want to save my picture path in my database and the name of my picture always same as my design_no column


For example i want to save a picture in my database i will copy my picture in d:\shahzaib\1234.jpg

now i want the path d:\shahzaib\ save in database and when i copy my picture which path= d:\shahzaib and file name = Design no its will automatically save in database


Regards

Shahzaib

Re: Image Path save in database and image name as Design no [message #407390 is a reply to message #406333] Wed, 10 June 2009 01:22 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Please post your code.

David
Re: Image Path save in database and image name as Design no [message #407466 is a reply to message #406333] Wed, 10 June 2009 05:19 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Thanks for your reply David

I Am be able to see picture in my form and also in my report

But now i need that user cant give filename to save the picture for example i create a folder in d:\ which name is Filename and when ever i copy the picture which name equal to my Sytle no the picture automatically save in my database

I am using a button to save picture in my database which trigger is

read_image_file( :block3.filename, 
                 'JPG', 'block3.image72' );


Regards

shahzaib ismail
Re: Image Path save in database and image name as Design no [message #409283 is a reply to message #407466] Sun, 21 June 2009 23:26 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'webutil' function 'client_get_file_name'.

David
Re: Image Path save in database and image name as Design no [message #590316 is a reply to message #409283] Wed, 17 July 2013 01:58 Go to previous message
noodle758
Messages: 1
Registered: June 2013
Junior Member
thx for the useful info posted by guys .

Im new here .to be frank,I encountered specific problem while saving
image
.and very glad that this page has helped me out.
Previous Topic: IMPORTANT,,how to get total records & total amount
Next Topic: EBS Form Text Field Enable
Goto Forum:
  


Current Time: Sat Nov 09 19:54:57 CST 2024