This content has been marked as final. Show 13 replies
Oracle Peon wrote:Do a workaround,
I'm new to oracle but I'm wondering if this can be done. I am using Oracle Forms Builder 10g and I can get my image to load if I use
READ_IMAGE_FILE('c:\ Assignment\DB\TEST.JPG', 'JPEG', 'IMG_LOGO');
The DB folder contains my forms (.fmb) files & I was wondering if there's any way to use the same folder wherever the .fmb file is something like
READ_IMAGE_FILE('.\TEST.JPG', 'JPEG', 'IMG_LOGO');
But that doesn't work. I want to be able to move my folder without having to go in and change the code for every instance I have an image loaded.
Any help would be great.
The Oracle Peon...
hold your image path at database and use this when read any image file.. whenever you change the location just change in the db.
Hope this helps
Did you mentioned FORMS_PATH into default.env file.
Don't think that'll work for me. When it'll be time for presentation and later on submission I'll have to put it on a removable media and the system it'll be checked on I wouldn't have access to or know what the
drive letter is going to be or change the configuration file. This is why I wanted to be able to look in whatever folder the .fmb file is loaded from.
Edited by: Oracle Peon on Apr 11, 2013 3:58 AM
But surely you wouldn't want your forms to be loaded from a removable media device?
Wouldn't you want your forms to be in a standard defined system location on your server?
It seems to me that you need a better process and structure for managing the images and their location.
I get that but this is for class and having it work for the presentation and when the marker pops it in his/her computer I wouldn't have the luxury of changing their configuration files or placing the image files into specific folders on their C drive. What I want to know if there is any way to point to the, let's call it present working directory, the directory where the form file (.fmb) is located?
Ok, that's the problem, we're business systems people and think that you have a business type problem that you need help with.
So we try and offer a business systems/enterprise solution, not imagining you're looking for help with your college studies.
That's ok. But the problem isn't really with where the forms are but where the image files are so if I moved both the image files with the form files the forms will still find the image file because it is looking in the same folder that the forms file is currently residing in. The question is can it be done and if so how? '.\filename.jpg' does not work and I'm wondering why.
On each Application Server you can add an environment variable that contains the FMBs path in the default.env file, then read the content of that variable at rubntime via the TOOL_ENV.GETVAR() built-in.
We may be onto something here. Is there anyway to call the path of the Form that has been loaded? Something like a show me the full file path of this form.
Did you try completely without path, like
READ_IMAGE_FILE('TEST.JPG', 'JPEG', 'IMG_LOGO');
Yup. No go.
On a side note. Does 10g support images with transparent backgrounds? I made a transparent gif and it came out black.
Ok guys I think the bottom line is that it cannot be done so I'm going to go ahead and mark this as answered.
Thank you all.