WHEN_BUTTON_PRESS using trigger mode on button
means when i click the button to load a image from the drive c or d the of jpeg format then i select him and upload
so write down the procedure in 6i form and send me the file of fmb format to mail me
send me the file
[URL]....
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 [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.
View 1 Replies View RelatedIs there any way to connect any scanner to the Form 6i. Before someone made Fujitsu scanner Fi 5120C to work with Oracle form that if a button is pressed, the scanner will scan the document which is placed inside it and saved in DB in blob column. But now this scanner is obsolete and discontinue. I don't know how that programmer had done because I didn't find any huge coding behind that button except the HOST (default procedure) and an exe file.
PROCEDURE Do_Image (MailId IN arc_mails.mail_id%TYPE,
IMode IN VARCHAR2) IS
DepName VARCHAR2(100);
[Code]....
FRM-10102: Cannot attach PL/SQL library XXX. This library attachment will be lost if the module is saved.I am getting above error message while opening Oracle 6i Form in 10g.
I get the following Alert message when I try to attach the library to my form - Attached library name S:.........xxx.pll contains non-portable directory specification. Remove path? Yes/No?
If I select 'No', the Form compiles and runs without any error.But if I select 'Yes', I get the following error message: FRM-40039: Cannot attach library xxx while opening form.
All files (fmb, fmx, pll, plx) are on the same path. I detached and then re-attached the library but this didn't work for me?
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
whn u execute query i m unable to get the pic..
I am new to the Oracle forms,i want to attach a calender to my form. I followed the below process:
--> I have attached the LOV&Record Group of the item for which the calender is attached as ENABLE_LIST_LAMP LOV which is included in the TEMPLATE.fmb
--> Set the validate from list to 'NO' in the property palette
--> Then after in the trigger KEY_LISTVAL,wrote the code
calendar.show;
while compile the form i got an error component 'SHOW' must be declared
My client is Oracle 10G DS Forms Developer. The application server is on a Solaris 64 bit sparc system. I have copied all the forms and libraries to my forms directory under C:DevSuiteHome_1forms10g_rel1 from the application server. and placed the following directory in my FORMS_PATH in the registry entry.
Now I am opening up the forms in my Forms builder and running the form. I get this error. I have the attached library in the form but I still get this error:
FRM-40039 Cannot attach a library while opening a form
I want to attache an external file to a email using UTL_SMTP package.
A file which attach will be present in directory.
I want to display a specified image if not form_success!
declare
image_path varchar2(80) := 'C:R_ORACLEPHOTOS';
photo_name varchar2(80);
begin
:system.message_level := '25';
[code].......
I have a form that loads an image. Before storing the image on the database, I want to verify the size of the image. If the image is 0kb, I want to pop up a warning message and fail the load into the database.
I am using Forms 6i Version 6.0.8.23.2
In my explorer/menu form there is a image item, I want to display company logo in this image item therefore I am using read_ image_ file ('c:application LOGO.jpg','JPG','IMAGE53') in WHEN_NEW_FORM_INSTANCE trigger but image isn't showing.
View 3 Replies View RelatedI want to set image in back ground.but there no option in properties.how to set back ground.
View 3 Replies View Relatedi want do add a image as a button.i added iconic image on a button from desktop,but its not working during runtime,i only see a flat button instead of iconic..what should i do...??
View 2 Replies View RelatedI Want Read Image Through URL..Image Is Placed In Another Server Which Is Not in Local Network.
View 1 Replies View RelatedI can send mail with UTL_MAIL using this:
CREATE OR REPLACE PROCEDURE send_mail_file_seti IS
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2(
sender => 'mail@from.com',
recipients => 'mail@to.com',
message => '<HTML><BODY>See attachment</BODY></HTML>',
[code]........
What I want to do is send mail attaching a file from file system. For example, I have this file:
/oracle/pmp/file
I want to send it using a procedure like the one above.
we are having a test server in bank environment.
Details:
IBM p series servers
AIX 5.3
Server memory : 16G
there are 2 instances on this server.
1. Near DR - 9840M
2. Test server - 1344M
Rest is for server.
Oracle 10.2.0.3.0 - Production
2 days ago we are running a stored procedure on this test server. After some time DB gave this error and stored procedure stopped.After that we were unable to login through Oracle Client Software. Whenever we try to login to this DB through client software, it gives following errors.
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System /6000 Error: 13: Permission denied
We tried to shut the DR database and then login but still gives error..
I am failed to saved image in the table via forms. (Although i have successfully updated the table with a procedure at PL/SQL level).
Here is what i have done.
1) Table created
create table prod
(pcode number,
image blob);
2) Made a form with guidence present at orafaq
3) It reads and saves image BUT enter/execute query does not show the image
4) even the following code gives me 0
select dbms_lob.getlength(image) from prod
Is it possible to add some custom image on a button?
If so, How to do it?
How can i capture an image using webcam connected to my PC and show that in the image item in my d2k form 6.0.I want to get the function in a when button pressed trigger.
View 16 Replies View Relatedhow can change image through runtime i mean if have 5 pictures first image will showing and second image showing
View 1 Replies View RelatedI have upload an image in forms6i, in oracle apps
On button press event, code is...
DECLARE
V1_PATH VARCHAR2(50);
BEGIN
V1_path := get_file_name('C:IMAGE', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
DECLARE
[code]....
But it giving error message when preesing the button i.e. FRM-47105: NO image name specified.
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]...
I was confuse about oracle applet parameter form that's in formsweb.cfg at line
# Forms applet parameter
background=C:imagea.jpg
but when i run oracle form it's still not appear image that i want to appear with a.jpg . how to change background of oracle form.
I have 100 image file in C:My_PIC/ i want read these image files and put in a table .
My table have 2 column : Id_pic varchar2(20) ,
PIC BLOB
I want read all files in C:MY_PIC and Insert in My table with a BUTTON in My form
ID_PIC = file name
PIC = image
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.
View 9 Replies View Relatedscan 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 trying to use read_image_file property , and it worked ,but unfortunately , the image is not adjusted with the canvas,
i changed the sizing style property to (adjust) , but also vainly , it is not adjusted with the canvas
We are upgrading from forms 6i -> 11gr2 I just noticed that our 6i image Show pallete property does not exists anymore in 11G...why the hell did they remove it!!!! it is a must for our users, since they need to zoom in and out to confirm acuracy at all levels.
Is there anything built in forms 11G that can zoom in/out of images. not finding anything. and once zoomed, do the horyzontal/vertical scrolling bars appear?
I have an .xls file which needs to be the last page of an rdf report. I would prefer to not type up the contents of the file and lay them out. Is there some way I can link this to the footer section or any other alternative?
View 2 Replies View Related