OraFAQ Forum: Forms » GET LOAD IMAGE SIZE BEFOR SAVE DATABASE

Home » Developer & Programmer » Forms » GET LOAD IMAGE SIZE BEFOR SAVE DATABASE (6i,Oracle Forms,DB 9i,windows xp) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605503]

Fri, 10 January 2014 01:45

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

i m using get_file_name built-in on when-button-pressed trigger and save image in database BLOB datatype, every thing is going smoothly but i have a requirement that if load size is more then 25 kb then user unable to save this image with
message ('Image Size is more then 25kb ');
.....

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605577 is a reply to message #605503]

Fri, 10 January 2014 15:46

nait1234
Messages: 29
Registered: August 2013
Location: Edmonton

Junior Member

You can use Webutil to get a file size.. not sure if you're using it already for getting the file from the user, but something like:

IF WEBUTIL_FILE.FILE_SIZE(filenameandpath) < xxxxxmaxbytes THEN
... process the file
ELSE
... spit out error message
END IF;

Hope that helps.

edit: sorry, I missed that you are using "get_file_name" built-in for getting file, but WEBUTIL_FILE.FILE_SIZE should still work for your case.

[Updated on: Fri, 10 January 2014 15:48]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605598 is a reply to message #605577]

Sat, 11 January 2014 13:35

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

its easy way to resolve this problem to get image size Attached "D2kwutil.pll"

:block3.a := Win_API_File.File_Size('C:\my_image.jpg', TRUE);

see in screen shot.

Regard
Mughal

Attachment: get_image_size.PNG
(Size: 43.66KB, Downloaded 1637 times)

[Updated on: Sat, 11 January 2014 13:35]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605599 is a reply to message #605598]

Sat, 11 January 2014 13:37

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

if you are still facing any problem let me know i will send you .fmb file according to your requirement.

Regard
Mughal

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605661 is a reply to message #605577]

Mon, 13 January 2014 04:10

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

thanks 4 reply dear
but i m using form 6i and and 9i DB

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605699 is a reply to message #605661]

Mon, 13 January 2014 13:28

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear @kashif_khan8281 above code specially works for only in forms6i try this.

take this .fmb which is acomplished in forms 6i just attached "D2kwutil.pll" as i shown you in my previous post screen shot.

Regard
Mughal

Attachment: get_image_size.fmb
(Size: 40.00KB, Downloaded 1790 times)

[Updated on: Mon, 13 January 2014 13:31]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605718 is a reply to message #605699]

Mon, 13 January 2014 16:56

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

See in the picture how D2KWUTIL.PLL attached

Attachment: attached_D2k_6i.PNG
(Size: 55.92KB, Downloaded 1680 times)

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605719 is a reply to message #605718]

Mon, 13 January 2014 17:16

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

see in the picture i developed according to your requirement by using forms 6i.

Regard
Mughal

Attachment: accordin_to_you.PNG
(Size: 78.97KB, Downloaded 1301 times)

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605814 is a reply to message #605719]

Wed, 15 January 2014 02:07

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

thanks sir... i m still facing problem after attach d2kwutil.pll
Error is
FRM-40734 Internal Error PL/SQL error occurred
attaching jpg

Attachment: get_image_size error.JPG
(Size: 114.98KB, Downloaded 1240 times)

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605834 is a reply to message #605814]

Wed, 15 January 2014 03:42

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear no problem

FRM-40734: Internal Error: PL/SQL error occurred.

Cause: A fatal error occurred in PL/SQL during trigger execution.

Action: Notify the DBA.

Level: >25

Type: Error

ctrl+shif->K COMPILE ALL FORM

And the main thing copy these three files in forms6i-->Bin--folder

1.d2kwut60.dll----Specially this
2.D2kwutil.pll
3.D2kcomn.pll

Then Run your form.

Hope your problem will be solved.

Regard
Mughal

[Updated on: Wed, 15 January 2014 03:46]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605887 is a reply to message #605834]

Wed, 15 January 2014 23:41

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

Asalamu-Alicum sir
i am unable to find this d2kwut60.dll
give me solution Smile

Smile

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605898 is a reply to message #605887]

Thu, 16 January 2014 02:22

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

post your email id i will send u.

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605925 is a reply to message #605898]

Thu, 16 January 2014 05:33

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

kashif_khan8281@yahoo.com

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605937 is a reply to message #605925]

Thu, 16 January 2014 06:52

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear Check your email all three files i have sent to your email account download all these files and copy into Forms6i--Bin--Folder

and run this fmb file which totally according to your requirement

Regard
Mughal

Attachment: call_image3_image_size.fmb
(Size: 48.00KB, Downloaded 1642 times)

[Updated on: Thu, 16 January 2014 06:53]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #606037 is a reply to message #605937]

Fri, 17 January 2014 22:57

kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN

Junior Member

sir i still facing problem at download form my yahoo mail account

Attachment: error2.JPG
(Size: 130.62KB, Downloaded 1218 times)

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #606041 is a reply to message #606037]

Sat, 18 January 2014 03:19

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

ok now try, go to your mail & download

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #646855 is a reply to message #606041]

Tue, 12 January 2016 01:26

riffatchishti
Messages: 3
Registered: January 2010
Location: Multan, Pakistan

Junior Member

sir..

i have 1 problem related uploading of Images in oracle 10g database.
when i upload images into oracle table it maximize size of each image. for example i have uploaded a file with size 200kb. in oracle table or even after retrieving from database its size gos to 400 kbs. how can i handle this issue. waiting for your kind attention plz.

Regards

Riffat

Report message to a moderator

Previous Topic:	Add (+/-) Button Number Increment
Next Topic:	FRM-40209 Field must be of form Error in Forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 05:26:39 CDT 2024