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 ');
.....
|
|
|
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 #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 #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
|
|
|