I am using developer 10.1.2.0.2 I have created a table to store the BLOB, which is jpg image originally. And I have uploaded those image into the database successfully.
Table name: images img_id number img blob
I know that I can set display one image each time if I create the image icon on the form using "data block wizard"..But the problem is that I cannot display multiple image on a form at the same time
I have a blob column in one table. I need to show it in my form (6i). If i put an image file in the column, it works (because i show it in a Image item type) but if i put a text file in the blob column, it does n´t work.
i m getting some problam to display image in forms 6i.
i hv two tables 1st is empmst emp_code number(5) not null (PK) emp_name varchar2() not null 2nd is emppic emp_code number(5) not null (FK of empmst) emppic blob not null
i create a master detial form and save the data in tables
I have just started using Oracle Application Express 11g. On my new attempt I am able to develop a table, report and a form, but I am not able to display picture image on the form though the browse link is active.
I can load the file name from the location folder to the form but it does not display. When I click on APPLY CHANGE then everything disappears. My main problem is how to successfully configure the settings for image display.
I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
how to display an image(blob) on a form . i have tried all i could but still failed to display it on the form.Yes i searched the forum without any break through. below is the code i used to create data block and upload photos (JPG). the only problem am facing is retrieving them from forms. am using form 6i 10g database.
grant connect, resource, imp_full_database, exp_full_database to en;
grant create any directory to EN; grant create any library to EN; GRANT EXECUTE ON CTX_DDL en; CONN en/en@pacific Connected [code]...
How to invoke and display a scanned image side by side with an Oracle Form without minimizing one of the two. I used the code below to call my document, but when i navigate to it so as to be able to see the detail , the oracle form will be dismissed and vice-versa.
DECLARE v_claim varchar2(400):=:global.photo_path||:b4.doc_no||'.JPG'; BEGIN client_Host('cmd /c START "" "'||v_claim||'"'); [code]....
I have a table named PRODUCT (ID Number , ProductImage BLOB). I have inserted some records in. I want to create a form for user to view this table.
When I create Data Block, in Data Block Wizard, if I select option 'Table or View' to retrieve data, it's ok (Data type of item ProductImage is Image, when I run form and query, it display image normally).BUT, I want to retrieve data from stored procedure in a package. This is my package
PACKAGE my_pkg IS TYPE my_rec IS RECORD ( myID PRODUCT.ID%TYPE, myImage PRODUCT.ProductImage%TYPE );
[code].....
I select option 'Stored Procedure' in Data Block Wizard, then select my stored procedure (my_pkg.Do_Query). Next I choose 2 columns from my stored procedure (ID, ProductImage). The wizard still applys data type of ProductImage as Image. I finish Data Block Wizard and Layout Wizard... run form, query and an error message display:
FRM-40364: The data type of item 'ProductImage' does not match the corresponding column in the stored procedure.
I try to change 'myImage PRODUCT.ProductImage%TYPE' -> 'myImage BLOB' in my package but still get that error.
How can I replace an existing image with a new one on my splash screen. Here's what I mean by this:
I have a form which already has a splash screen logo. This logo will be replaced with a new one. The existing logo is attached as an image in the form of a .tiff file. There are no triggers on the form excepting a "when new form instance" which just says "SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,TITLE,'ABC').
How can I ensure that the old logo is replaced with a new one. Here's what I did to replace, i.e my trouble shooting steps:
a)opened the form and deleted the existing splash screen/.tif file b)went into the layout editor and clicked on "EDIT-> IMPORT" and mapped it to the .tif file that's persent in the local directory. As soon as I click OK, I get the following message :
FORMS-VGS-507- Cannot open file or file not in specified format.
BTW- another trouble shooting step was that I discarded the original and the one to be replaced .tif file. After this I imported another .tif file , so as to eliminate/narrow down the issue. The other .tif file when imported, attached itself perfectly fine, except that it was too large. (How to crop the size). I am new to Oracle forms10g and my area of work is pl/sql,sql,crystal reports and VB.
I'm facing a really strange problem in Forms with an FMB that has a couple of canvas, but the main one canvas is showing a JPG (like a Wall Paper for the application, in fact this FMB would be the main FMB and it will call the main menu also). The problem is on run-time (locally, running on windows, just in some Laptops). At execution time, there's a FRM-92102 error, but only deleting the image, and trying again, the Screen run perfect!
The worst part is that same FMB run perfect on other laptops. I've tried almost everything : Creating again, just the form with one canvas and importing the image, and Run, but same error appears again. Trying with another image, same results.
I Created a form just for testing purpose [Which is i attached]
My Table is TEST0
Structure of table : --------------------------- NOVARCHAR2(5) NAME VARCHAR2(10) FLG VARCHAR2(1)
My Task is When i added a record, e.g if on form, i add name - AAD But its must save on TEST0 Table like this way EMPAAD...means always concate with 'EMP'||:Block.name while saving on database..
I know how to do with front end application, but i want to achieve this task by using trigger on backend databse...how to create a Trigger on backend....i try a one trigger but it give me error- Unable to insert Record...
I have a problem running forms 11g OS is windows 7 (tried on both 32bit and 64 bit same error)..Forms and Reports were both working fine, i was able to run test form, and a form that i created, and both were running properly. suddenly, while testing a new form module, it didn't work, and its showing :
Failure of server APACHE bridge: ------------------------------------------------------------------------------ No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
i want to know the backend process of Oracle DB.because when ever we are taking about DB , so many things are coming into pictures like Physical,logical structures,instance,schema,servers,storage and all. Actually i know what is oracle and why we are using that .
its show me in this website [URL] 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:shahzaib1234.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.
i want to create a simple form in this form i want to upload the image on the image item with browse button that open a diaglog box that go to the image i select the image and this image is display on image item on the form.
I have a table which contain 3 columns, see below:
id primary key pic1 blob pic2 blog
there is 1 row in it(id=1), just for display 2 images.
Uploaded 2 images into above Blob fields by file browse function. Now, I want to show the 2 pictures in a Region by using display image item P1_AR, but it didn't work.
Based on: BLOB Columns specified in item source Alternative Text Column: null Filename Column: null BLOB last update Column: nullSource used: Only when current value in session state is null Source type: SQL Query(return single value) Source value or express: select dbms_lob.getlength(PIC) from cp_pic where id=1
I got the error below after runing: ORA-20999: P1_AR has to have a valid BLOB column as source
i am working with image. I have successfully stored image in oracle table. Now i want to display the stored image in oracle form 6i. There i unable to display the image although i have created the data block using the same table name as the data source.
scan image from Oracle Form Builder 6i and store the image location in the oracle 9i database. Here important issue is we just store the image location in the database not the image. We'll store the images in a storage device and store the location path in the database. And retrive the image from storage device using the path.
For example: User Scan the image using Form builder 6i then save the image like 1001-DPS-1.jpg in the default location like D:Image.. And in oracle 9i database data save like : 1001 DPS 1 D:Image1001-DPS-1.jpg User_Name Sysdate
Data save automatically in the database when image scanned and saved in physical drive. This is our main purpose.
Is it possible to solve this task using Oracle 9i and Developer 6i?
I am working on oracle forms 10g (Windows7 OS). Can we get the image resolution of an image item in oracle forms? Can we resize the image in terms of resolution? I have a requirement where user can upload only 1280x720 size images. Either i have to validate the image resolution and give them a message saying 'Only 1280x720 size images are allowed' or simply i have to convert the image to be upload to 1280x720 size and save in the database.