Forms :: Saving No Errors Shown And Neither Record Is Inserted

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


ADVERTISEMENT

Forms :: Database Blocks - Saving Record

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

Forms :: Stop Saving When Detail Record Is Null?

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

SQL & PL/SQL :: Saving Procedures With Compilation Errors

Feb 21, 2010

When creating objects, is there a way telling Oracle not to store(overwrite) procedures or other DDL in the database until the statements have no compilation errors?

View 4 Replies View Related

Forms :: Save Record In Table Before Saving Updated Version?

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

Forms :: New Record With Same ID Inserted Every Time - Duplication

Mar 4, 2013

I have a form that used to enter new employees , if the employee ID already registerd then the user can ONLY update the information and NOT adding the same ID with new info.

int the ID item in when-validat-item trigger I put this code

begin

IF :SOURCE_CODE IS NULL THEN MESSAGE('PLEASE ENTER SOURCE CODE');
ELSE
declare --chg#13-3169 nada

[Code].....

in the save button the code is : commit;

The problem Is : a new record with same ID is inserted every time !! Duplication is happining

View 6 Replies View Related

Forms :: Record To Be Inserted Into Table As Audit-trail Of Printing

Feb 3, 2010

I am using oracle developer 10g. I want to know the status of the printer where i want to print. If the running report is printing or in queue then a record is to be inserted into a table as audit-trail of printing. Idon't want to do it manually.

View 1 Replies View Related

Forms :: RTF Changes Not Shown For Specific Language

Mar 20, 2013

cookiemonster wrote on Wed, 20 March 2013 22:01Or if the user does anything to wipe the modified data - clear block, enter query etc - forms will also raise the alert.

i've uploaded a new RTF for Spanish but wen i login with the Spanish creds and run the program. Its not showing the changes i've chosen the right language and territory code.

View 1 Replies View Related

PL/SQL :: Last Inserted Record

Aug 7, 2012

I need select last added/inserted records where value = 'test1' and = 'test2' and = 'test3' in column 'NAME' should be one record for each 'test1','test2' ...

aslo..table have column 'DATE_USR' with data_type = timestamp(6)

View 12 Replies View Related

SQL & PL/SQL :: How To Find Which Record Is Inserted First

Mar 25, 2010

I have a table with lot of records.In this table, how do I find, which record is inserted just before a record in my question.

consider this example..
SQL> desc test1
Name Null? Type
------------------------------- -------- ----
SEQ_ID NUMBER
NAME VARCHAR2(1)

[code]....

in the above data, if I want to know what record is inserted before "1018", how can I find it.

Can we find out based on ROWID.?

View 13 Replies View Related

How To Find Last Inserted Record In A Table

Oct 5, 2010

I have a table where there is no sequence maintained and there is no time stamp column to track the inserted record.How do I find the latest inserted record in the table.

View 5 Replies View Related

SQL & PL/SQL :: Find The Time Of A Record Inserted Into Table

Oct 20, 2010

I have a table which is getting populated from a source. I dont have a time-stamp column in the table. Is there anyway to find the time when a record was inserted into the table?

View 3 Replies View Related

Forms :: Exit Without Saving?

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

Forms :: Saving Form To View On Web

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

Forms :: Saving Of Multiple Records At One Go

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

Forms :: BLOB Image Is Not Saving?

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

Forms :: Saving The Object Group

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

Covert A Time Shown As 001200 (12 Hours) To 720 Minutes

Feb 10, 2012

I am trying to covert a time shown as 001200 (12 hours) to 720 mins. I have tried the following but get errors when executing:

(MTTD)>=TO_DATE('000000','HH24:MI:SS').

I have also tried .

MTTD = to_date('000000','HH24:MI:SS') =trunc(sysdate,'MM')*24*60; and neither is working.

What am I doing incorrectly?

View 1 Replies View Related

Forms :: Saving Records In Tables After Updating

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

Forms :: Saving Mathematical Equations / Symbols Using 6i?

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

Forms :: Not Saving - Validation On Age Doesn't Work?

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

Forms :: Saving Excel Files As Object In Oracle?

Feb 13, 2012

How can we save Excel file as an objectin oracle. Like we can store image file.

View 1 Replies View Related

Forms :: Saving Data From Multiple Datablocks Into New Table?

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

PL/SQL :: Text Fields Getting Disappeared After Saving In Oracle Forms?

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

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 View Related

Forms :: DDE Package - How To Close Excel File Without Saving Changes / Messages

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

Forms :: FRM 40102 Records Must Be Inserted Or Deleted First?

Jul 26, 2011

How to avoid this error. FRM 40102 Records must be inserted or deleted first

i have used next_record.If i remove this it is working.but i need to use next_record built in.

View 8 Replies View Related

Forms :: Display Code Errors Above 10g

Jul 11, 2011

I have problem follow: i create a forms 10g and run it then errors. Now, i want to display code errors,how do i do?

View 2 Replies View Related

Forms :: Oracle 9i Errors On Startup?

Feb 11, 2011

We have an application that uses Oracle Forms 9i AS R2 that has been running happily for many years. There are two servers that run the client side application and provide the users with access to a single database. Two weeks ago one of the two servers started expperiencing issues, then yesterday the second server started experiencing issues also. The problem appears to relate to the Java component of the service. Typically what happens is that the user runs a batch file that starts the following java command:

C:OraHome1jdkinjava -Dorg.omg.CORBA.ORBClass=com.inprise.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.inprise.vbroker.orb.ORB -Doracle.security.jazn.config=C:OraHome1j2eeOracle9iDSconfigjazn.xml -Doracle.home=C:OraHome1 -DORACLE_HOME=C:OraHome1 -jar C:OraHome1j2eehomeoc4j.jar -userThreads -config C:OraHome1j2eeOracle9iDSconfigserver.xml

This should start a service that listens for connections on port 8888. Internet Explorer then fires up and establishes a connection to the listening port. Unfortunately we never get that far. We receive the following error and the Java service never starts so the IE conection fails to connect to the service on port 8888. unexpected exception has been detected in native code outside the VM.

Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC= 0x6d3f1992
Function name=(N/A)
Library=(N/A)

NOTE:
We are unable to locate the function name symbol for the error just occurred.

Current Java thread:
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1419)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1335)

[code]...

Dynamic libraries:
0x00400000 - 0x00405000 C:OraHome1jdkinjava.exe
0x7C800000 - 0x7C8C2000 C:WINDOWSsystem32
tdll.dll
0x77E40000 - 0x77F42000 C:WINDOWSsystem32kernel32.dll

[code]...

what could have happened?

View 6 Replies View Related

Forms :: Populating Values To Record Group From Multi Record Datablock

Jul 26, 2012

My procedure proc_ex is in when_validate_item trigger

I have one Multi Record data block in my form with values in its items

I need to Populate multi record block values to one Record Group using

add_group_row,
add_group_column,
set_group_char_cell to populate values to record group

Let us suppose my multi record data block looks like

item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80

how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved