Forms :: Saving As JFIF And GIF Works Fine Without Any Compression
Feb 5, 2013
I am using oracle forms 10g and basically we have a system that takes over 300 photos on a daily basis, this all works fine and with no issues except for say maybe 2-3 photos a month. Occasionally we will get a 'corrupt photo' (it not actually corrupt, it displays in everything as it should except forms) . When we encounter these photos forms just crashes out and the user is unable to query the record with the associated photo until it is deleted and a new one is taken (or alternatively if we take the photo from the database open it in paint.net and just hit save it will then work). There is no difference that we can see in the photo which doesnt work and those that do work. I have tried using WRITE_IMAGE_FILE to save the photo to disk and Read_Image_File to read from the disk to see if that makes a difference. If i save the file as jpeg and no compression it still crashes, if i save it with low compression it works fine but we lose quality which we dont want to lose. Bitmap wont work at all. Saving as JFIF and GIF works fine without any compression but we still lose quality.
The photo will display fine if we use a javabean to display it but in this instance a javabean is not an option.
One weird thing we noticed is that when we are on the form that crashes with these photos and query back a working photo first, and THEN query the 'corrupt photo' the corrupt photo displays fine, but if we go into the form and query a corrupt photo first forms crashes as explained.
View 1 Replies
ADVERTISEMENT
Aug 1, 2011
I tested the SQL in 11G and get the ORA-00979 (not group by error) , the same SQL is working in 10G.
553322.1 - ORA-00979 IN 11.1.0.6 BUT NOT IN 9I OR 10G
814423.1 - ORA-00979 AFTER UPGRADE TO 11G
Do we have simple soluation for it if I don't have Oracle support account?
View 1 Replies
View Related
Sep 28, 2012
Tabular form works fine for first entries, but upon going back to add more records Page 55 has a button that links to the 'Approval' page which is a tabular form (Page 56).A text field at top of this tabular form receives the pass of a varchar2 field from page X which is an identifier (not PK). Tabular form query has condition WHERE ISO_NUMBER = :P56_ISO_NUMBER
When I add records on the first pass to the tabular form and click submit all is fine and dandy.When I get out of the tabular form and go back to it and add additional records I get this error:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "C4B43B9A17A41D287D55DEFE9B035944", item checksum = "607C07E22C9B03E6A45AF44EDC06BB31"., update "SPICE_HUNTER1"."DOC_APPRV_DOC" set "APPRV_DOC_ID" = :b1, "DOC_INFO_ID" = :b2, "ISO_NUMBER" = :b3, "DOC_APPROVER" = :b4, "DOC_APPROVED" = :b5, "DOC_APPROVAL_DT" = :b6, "DOC_COMMENT" = :b7, "APP_USER" = :b8Here's what I've done to try to figure it out:
1. Ran debug and saw it was happening in my MRU; and
2. In the past what I have cleaned out tabular form table data because I've found that when I'm in this testing mode going back and forth with changes gets fouled up, but with a clean slate it still happens.
3. I had Hidden the ID fields, and then remembered this was one of the issues with versions of this error. (I actually logged this one to remember!). So I made them Display as Text (Saves State) and unchecked their boxes.
View 1 Replies
View Related
Dec 5, 2010
I have created one master detail form where on master i have one field with name status and if the status is changed to A it will prompt me to another detail block where i will fill the details and in case after i entered the details and then i decide it not to save and come back to main form without saving...how i can do it . I used go_blok In detail to go to master it goes to master but when i am saving the master the details get saved along with it.I dont want to save the detail and go to master block.
View 1 Replies
View Related
Jan 26, 2010
i have developed a form in 9i. can i view the fmx file on web. or tell me the extenstion what name of form should i use to save the form to view on the web.
View 5 Replies
View Related
May 17, 2011
My query is: I have created a master-child forms on one canvas. In a child form i have to enter multiple records, but after entering every record its prompting me to save it. I want to avoid it and save the entire thing once all my records are entered.
View 4 Replies
View Related
Nov 12, 2011
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
View 1 Replies
View Related
Dec 13, 2010
I've created Object Group which consists of (alert, parameters, visual attribute and property class). Now I want to save this Object Group.
View 3 Replies
View Related
Jun 26, 2012
declare
blk_name varchar2(60);
form_name varchar2(60);
[Code].....
this is my coding on save button. this is working fine but only once. when i enter the data second time and try to save, it didn't do anything. what should i do?
View 5 Replies
View Related
Jun 8, 2013
I AM WORKING ON FORM I WANT TO SAVE THE RECORD IN TO TABLES TABLE1,TABLE2 AFTER UPDATING THE
TABLE1..BOTH THE TABLE HAVE SAME COLUMNS'.
WHAT IS THE TRIGGER FOR THAT
View 2 Replies
View Related
Sep 4, 2011
i want to save mathematical equations / symbols. using forms 6i.
What characterset , font to be used.
(note, my client has equations written in MS Word 2007)
View 3 Replies
View Related
Oct 2, 2010
i am using form6i & oracle 8i.
i have master -detail form. both are database blocks.
i have inserted values for the master block bt not for the detail record my problem is.. "user should not be allowed" to move to next record of the master block before saving the current record
View 10 Replies
View Related
Mar 8, 2011
im now doin' my currently program, actually they requesting for an update. I added birth date column in the module,they asked to the request to put a validation on date, such as:
a. under age
b. :txt_ph_birthdate > SYSDATE
c. if :txt_plan_type = 212 then
17 yrs, 5 mos and 29 days and 40 yrs, 5 mos and 29 day - as validation
d. if :txt_plan_type = 214 then
40 yrs and 6 mos and 55 yrs, 5 mos and 29 days - as validation
e. if :txt_plan_type = 215 then
17 yrs, 5 mos and 29 days and above - as validation
they also instructed me to put the validations in birth date after the column of birthdate, which is the :txt_plan_type(list_item) and i put it in TRIGGER (when-validate-item)after i did the codes and compile it., theres no message for error but i think its not working..it working. i already updates also the insert and the other trigger and procedure, i just add the plan type on it.
i havent edit the save button because the as i read the codes the it just call the procedure that i edit.when i run the program and after i encode the data..and when i press the save button, nothing happens or any confirmation.in addition, why is it that my validation on age doesnt work?
heres the
declare
n_months_between NUMBER;
d_same_day_occur DATE;
n_years NUMBER;
n_months NUMBER;
[code]...
View 8 Replies
View Related
Feb 13, 2012
How can we save Excel file as an objectin oracle. Like we can store image file.
View 1 Replies
View Related
Feb 5, 2011
I have master detail block just consider Forms A as a master and Forms B as a Detail,when my cursor is in form A i try to save the record, it is saved Form A and putting Form B data as null, i have to put a validation to stop this activity, i have to inform the user "Provide values for form B text item",
I created a post block trigger in form A
Begin
If (:FORM-B.TEXT1 is null)l or( :FORM-B.TEXT2 is null)
then
Message( 'provide value for FORM-B');
Message( 'provide value for FORM-B');
raise form_trigger_failure;
ELSE
NULL;
END IF
END;
Im Getting error message and navigation got stopped in last item of form A itself,i need to show error message and cursor control should move to first item of form -B which trigger i have to use for this.
View 1 Replies
View Related
Aug 23, 2013
I have used a template to create a form which has 3 below tables / blocks in the form:
1.'OIFC_INV_DEVICE_TYPES'
2.'OIFC_INV_SECTIONS'
3.'OIFC_INV_DEVICE_MASTER'
The 1st 2 tables are used only to fetch values through a LOV and no insert happen during save and the 3rd has initial values defined and has to insert these values while click on the save (when button pressed trigger) button which has the below pasted code, but no error is thrown and neither the record is inserted,
declare
al_id alert:=FIND_ALERT('popup');
al number;
insert_val varchar2(500);
increment_value number;
MAX_VALUE NUMBER;
rec_check varchar2(1);
[code]....
View 1 Replies
View Related
Aug 19, 2010
I have a form with 2 datablocks, datablock 1 is the datablock in which I want to write data too that table within the database.
datablock 1(which i want to insert data too) is:
In forms layout this simply consist of a display box at the top of the screen which is populated by a LOV from another table within the database. The lov value selected will then be placed in the appropriate field of the table. For example the LOV contains a list of every single car make there is. i.e. Renault, Ford, Vauxhall etc
datablock 2 (in which i just want to read data from, and write the data to the table used in datablock1) is:
Below this is my second datablock, which on the trigger 'on-new-form-instance' reads data from an already existing table and displays a list of every single make of car ie, focus, clio, megane, astra etc (tabular layout displaying 12 records at a time). Beside these car models will be a checkbox which is a non database item, originally unticked.
What I want to do is the user selects a car type from the top LOV say Renault for example, then they will go down the list of car models checking each and every model of car Renault makes, i.e clio, megane, etc when these models are all checked, and the user clicks save, it will insert into my table (which is the top datablock) the car which was selected From the LOV at the top, plus each and every car model which has a checkbox checked. So for example, say the user selects Renault from the top LOV and checks models clio, megane, laguna. There should be 3 entries in the table consisting of:
Renault, clio
Renault, Megane
Renault, Laguna
Now I have got it to work partially, in the fact that if I load the screen, select my car type and then multiple models that it will add 1 car type and model to the database but not the others which I have checked. I think I need it to go down each row and check if the value is ticked or something like that? using row id or something?
Here is the code I have so far: Just so you know car_model is the name of my table used as my second datablock, contains all car models as u would expect.
BEGIN
if :model_chkbox = 'Y'THEN
v_model_id := :car_model.id;
INSERT INTO NOTE_ACCESS_DEFAULT (car_type, model_id)
VALUES (:car_type, v_model_id);
end if;
EXCEPTION
WHEN OTHERS THEN
MESSAGE('SQLERRM: ' || SQLERRM);
END;
Another option was to do a loop and go through each record and see if it is checked, not sure how I would implement this but it does seem like a very inefficient way to do such a task, perhaps it would be something to do with when a checkbox is ticked stamp it or something.
View 1 Replies
View Related
Mar 1, 2013
I have developed a screen using oracle forms.... it has 4 text fields..then a LOAD button.After giving i/p in the 4 text boxes user will save (ctl+S) ..then hit LOAD button ,which will populate the fields below the screen.Everything is working fine but only problem I am facing...when user is trying to save (ctl+S) after giving the 4 i/ps in the text fields....the text fields getting disappeared and also becoming editable...though the data they have already given is being populated in the table..I want ..even after pressing ctl+S...the data should be there & non-editable.
View 2 Replies
View Related
Apr 6, 2013
I have a multi record block . I need to implement a functionality where the user updates a field in the record but the form saves the previous version of the record in another table ..
View 3 Replies
View Related
Nov 19, 2009
I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.
I am using THe DDE package and when using
DDE.EXECUTE(convid, '[Save()]', 10000);
there is no problem, but the changes are saved. I have tried '[Exit()]' and '[Close()]' but always have error message ORA-106555. Is there any way of doing this without errors?
View 11 Replies
View Related
Jul 9, 2010
I have some trouble with a stored procedure I've created, when I run it in the server dedicated to developers it runs fine, and updates 100,000 record in 23 seconds, but when I run it in the production server it collapses and don't update anything. Here's my code.
CREATE OR REPLACE PROCEDURE cdc_sp_comp_tablas_paudit IS
TYPE t_folio_log IS TABLE OF cdc_compara_consulta_paudit.nconencfolio%TYPE;
v_folio_log t_folio_log;
CURSOR c_folios_bd IS
SELECT a.nconencfolio
FROM cdc_compara_consulta_paudit a
, cdc_consulta_encabezado b
WHERE a.nconencfolio = b.nconencfolio
[code].......
I'm using Oracle 9g,
View 10 Replies
View Related
Feb 1, 2013
trim down the following sql to within 255 characters help:
select indate
from (
select case count(inputDate)
when 1 then inputdate
end as indate
from commLeaseBut5
[code]...
This sql is check a date field in the database for record which, if the date field is blank it should be a new record. Then the sql will assigned the current timestamp and stored to the new record. Otherwise, the sql will return the record timestamp for display.
View 7 Replies
View Related
Apr 23, 2010
How can i see all of the objects that are included on the policy of fine grain access control method?
View 2 Replies
View Related
May 9, 2012
I've developed a TAB delimited sql report and the report is not opening well in notepad and the same report is opening good in textpad.
create table testex(tmple_tmpl_date date,column_string varchar2(20),cnt1 number,cnt2 number,amount number(22,2))
/
Insert into testex
(TMPLE_TMPL_DATE, COLUM_STRING, CNT1, CNT2, AMOUNT)
Values
[code]...
and here is the report code
SET FEEDBACK OFF
SET VERIFY OFF
SET UNDERLINE OFF
SET NEWPAGE NONE
SET LINESIZE 999
[code]...
View 6 Replies
View Related
Mar 25, 2013
We have started developing a new application to compress tablespaces based on the business specification.
This is a Data Warehouse.
Version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
And there is a requirement to find the uncompressed segments,to find whether the tablespace is already compressed or not.
View 1 Replies
View Related
Aug 22, 2011
We are seeing volume issue when taking Rman level 0 backup for a database , the database version is 11.2.0.2 and its on RHEL 2.1. As 11g supports compression for RMAN, we have implemented so as to reduce the backup space used.
" CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE "
However during full backup the volume size increases, meaning we have to increase /data volume (currently 500G) to more then a 1T for just rman to go through, else the backup hangs. Once backup is done we again bring down the volume size to less then 1T. The other compression parameters are HIGH and MEDIUM, hoever I am not very sure if changing to high or low will work as I couldn't find any right doc in meta link or may be I didn't searched correctly, I will continue to look for that.
View 2 Replies
View Related
Aug 8, 2012
Hybrid Columnar Compression is dependent on the underlying storage system. See Oracle Database Licensing Information for more information.
The below is from the Oracle® Database PL/SQL Packages and Types Reference
Compression Constant Compression Level Description
COMP_FOR_OLTP 2 OLTP compression
COMP_FOR_QUERY_HIGH 4 High compression level for query operations
COMP_FOR_QUERY_LOW 8 Low compression level for query operations
COMP_FOR_ARCHIVE_HIGH 16 High compression level for archive operations
COMP_FOR_ARCHIVE_LOW 32 Low compression level for archive operations
To use Compression Level 4 or higher do we have to have ZFS or Pillar storage ?
View 4 Replies
View Related
Jul 13, 2013
Database version: 11.2.0.3(Exadata)
We want to use archive compression for our standby(standalone non-exadata). We don't have license for Advanced Compression. Is the archive compression possible without Advanced Compression?
View 0 Replies
View Related
Mar 22, 2011
We are trying to add 2 columns in a partitioned table.but we are getting below error:
SQL Error: ORA-39726: unsupported add/drop column operation on compressed tables
But, it is not a compressed table.
select table_name, compression from user_tables
where table_name ='SVC_ORDER_CODE_FACT'
TABLE_NAME COMPRESSION
------------------------------ -----------
SVC_ORDER_CODE_FACT
actually we are trying to add 2 columns as below:
ALTER TABLE SVC_ORDER_CODE_FACT
ADD (MKT_FEATURE_KEY NUMBER default '-2', PREV_MKT_FEATURE_KEY NUMBER default '-2');
But, if we add column without default value,
View 2 Replies
View Related
Jun 21, 2012
I had created a Primary key and wanted to compress as per my senior instructions.Below are my results the size increased after compression.
select compression from dba_indexes where index_name = 'TEST_IDX';
Compression
----------
DISABLED
select sum(blocks) no_of_blocks, (sum(blocks)*8192)/(1024*1024)size_MB
[code]....
We ran a compression on the primary key index TEST_IDX
ALTER INDEX SCOTT.TEST_IDX REBUILD INITRANS 15 TABLESPACE DATA_01 COMPRESS;
ANALYZE INDEX SCOTT.TEST_IDX VALIDATE STRUCTURE;
Now when i ran the below select statement:
select compression from dba_indexes where index_name = 'TEST_IDX';
Compression
----------
ENABLED
select sum(blocks) no_of_blocks, (sum(blocks)*8192)/(1024*1024)size_MB
[code]....
As you can see after compression the blocks and size has been increased, but i ran for many tables and other indexes, we observed the blocks and size was reduced by 50-70%, i am not sure why this happened to the index compression.
View 3 Replies
View Related
