i have to build up a form for visitor pass in my company..for that i have to capture visitor's image by web cam. my problem is that how to capture image form web cam to my form for each visitors.
How to integrate my web cam with my oracle 6i form builder.
I want to capture video using webcam through developer 6i. i m using ora_ffi package. my package specs are:
PACKAGE CAM IS
WM_CAP CONSTANT PLS_INTEGER:= 1024; -- EQUALS TO '&H400S'
WM_CAP_DRIVER_CONNECT CONSTANT INTEGER := WM_CAP + 10;
WM_CAP_DRIVER_DISCONNECT CONSTANT INTEGER := WM_CAP + 11;
WM_CAP_EDIT_COPY CONSTANT INTEGER := WM_CAP + 30;
WM_CAP_GET_STATUS CONSTANT INTEGER := WM_CAP + 54;
WM_CAP_DLG_VIDEOFORMATCONSTANT INTEGER:= WM_CAP + 41;
[code]....
package body are:
PACKAGE BODY CAM IS
/* Declare the library and function handles. */
USER_LIB_HANDLE ORA_FFI.LIBHANDLETYPE;
AVCP_LIB_HANDLE ORA_FFI.LIBHANDLETYPE;
FH_SM1 ORA_FFI.FUNCHANDLETYPE;
FH_SM2 ORA_FFI.FUNCHANDLETYPE;
FH_SM3 ORA_FFI.FUNCHANDLETYPE;
[code]....
now i call preview window through 'when-button-pressed' code is as:
DECLARE
IDEVICE INT := 0;
IHEIGHT INT := GET_ITEM_PROPERTY('BLOCK3.IMAGE',HEIGHT);
IWIDTH INT := GET_ITEM_PROPERTY('BLOCK3.IMAGE',WIDTH);
BRETURN BOOLEAN;RS INT;
S CAM.CAPSTATUS;
IMAGE_ID INT;
[code]....
when i run form, i will get "FRM-40734:internal error:PL/SQL error occurred.". i checked form through debugger,it gives me "PDE-PPU007" error on this function BEGIN CLAUSE execution.
FUNCTION CAPCREATECAPTUREWINDOWA(LPSZWINDOWNAME VARCHAR2,DWSTYLE INTEGER,X INTEGER,Y INTEGER,NWIDTH INTEGER,NHEIGHT INTEGER,HWNDPARENT INTEGER,NID INTEGER) RETURN PLS_INTEGER IS
BEGIN
RETURN (FF_CAPCREATECAPTUREWINDOWA(FH_CPW,LPSZWINDOWNAME,DWSTYLE,X,Y,NWIDTH,NHEIGHT,HWNDPARENT,NID));
END CAPCREATECAPTUREWINDOWA;
I have one requirement,i need to capture the details keystrokes of what user is entering in the form.
View 4 Replies View RelatedIs there a way on oracle forms input field to capture each key stroke. Like if I type "abcd".... After each letter is typed can I check contents of input field.
I tried almost all triggers in the input field however none of them capture every keystroke.
I am trying to insert In multiple table where one tbl PK is FK of other , I achieved that functionality using Instead of Insert trigger.(PK is handled by another trigger) -- main functionNow On successfully insert i need to captured the PK in Hidden variable to pass it on further for more insert on other table (Pk again being Fk to this table)--- secondary function
View 6 Replies View RelatedI 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 Relatedi 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 want to store image and pdf files in oracle 10g.
i success with blob variable.
what are the other methods.
i am storing image in label how to return for calling place.
View 1 Replies View RelatedI 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 am currently working on project which is basically development is going on Java Spring and Oracle 10g
I have a problem when i am calling the procedure from Java GUI
I am created directory named IMAGE_DIR
CREATE OR REPLACE PROCEDURE u_rfnd_cnd_test
(ackno in varchar2, p_name IN u_rfnd_cnd_petition.URCP_IMAGE_NM%TYPE) IS
v_bfile BFILE;
v_blob BLOB;
BEGIN
INSERT INTO u_rfnd_cnd_petition (URCP_ACK_NO, URCP_IMAGE_NM, URCP_IMAGE)
VALUES ( ackno,p_name, empty_blob())
RETURN URCP_IMAGE INTO v_blob;
[Code]..
When i m calling this procedure from Oracle itself its working fine
But when calling this procedure from Java GUI with same parameter then i am getting error
But still i am getting an error saying.
Error :java.sql.SQLException: ORA-22288: file or LOB operation FILEOPEN failed The system cannot find the path specified. ORA-06512: at "WBCOMTAX.U_RFND_CND_TEST", line 18
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 RelatedWHEN_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 have two cases
i . Convert Image to Hex String
ii . Convert the Hex Sting to Image
Case i is done, is Case ii is Possible in Oracle 11g Rel 2..?
I am attempting to Insert an image "C:/hi.jpg" into oracle10g with BLOB using SQLPlus.
I have created a table IMAGES...
CREATE TABLE IMAGES (
ID NUMBER(4) PRIMARY KEY,
IMAGE BLOB
);
Is that a correct way to start? How would you upload the image onto the table?
I have a table with a blob type field. We need to read scanned documents (doc, pdf, tif, jpg, etc.) from a specified directory and insert relevant data into a table, including the document as a blob.
View 3 Replies View RelatedI 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?
I want to store Image file in Oracle table without storing it physically in the system. how can i store the image file into the oracle table and also retrieve it without storing it physically in the system at any path.
View 5 Replies View RelatedHow 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 attach an IMAGE in XML and that will be used in PL SQL procedure to generate the Excel file with the IMAGE. I cannot able to save the xml as excel with the image
View 3 Replies View Relatedhow 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.