Forms :: Post Change Trigger

Jun 12, 2012

I have an issue with the oracle forms trigger. This is the scenario. The form is a query only form . A user can only query on this form . No update or insert is allowed.

The base table say TABLE1 consists of these fields. 1) pro id, pro item, empno , fname, lname, deptno .

The user can query on all items except the fname and lname.

The issue is few records in the TABLE1 have null values for the empno.

When the user queries on proid, pro item , empno or deptno - when the empno on TABLE1 is not NULL , the fname and lname should be fetched from a different table say TABLE2. otherwise, if the empno on TABLE1 is null , the fname and lname from the same table i.e, TABLE1 are retrieved. I have tried with the post change trigger on empno . Also tried the When validate item trigger . But it doesnt work the way it is expected to. what is the appropriate trigger that must be used.

View 22 Replies


ADVERTISEMENT

Forms :: If Condition In Post Change

Jan 23, 2013

I have a view t1 having the records:

1 A
1 A+
2 B
3 C
4 D

I want to display that in an LOV but without the first record (1 A) I used the code :

SELECT DISTINCT num,
DECODE(num,1,(SELECT DISTINCT desc FROM t1 a
WHERE a.desc='A+'AND a.num=1),desc) desc
FROM t1

this worked fine but how to apply this in a post_change trigger where a user inters the num and the desc appears in atext-item in my form

View 1 Replies View Related

Forms :: Post-change Versus Validate Item

Oct 20, 2010

tell me excat diff. between when- validate -item vs. post-change in a simple way...

View 4 Replies View Related

Forms :: Post Query Trigger With Cursor

Jan 11, 2011

I create a master detail form. I created also a post quey trigger, inside I wrote the code below.A cursor looks to another table and returns to the form some values i need!

declare
cursor C1 is
select apofaa, startdate, enddate, transport
from trapofdet
where trapofdet.apofcode = :trapof.apofcode;
[code]....

How to solve the

a. frm-40737, illegal restricted procedure go block in post-query trigger
b. It seems tha returns all the records but it appears only the last one.

View 2 Replies View Related

Forms :: After Post Trigger Go To The Specific Item?

Feb 8, 2013

I have this layout

[URL]

and a post trigger insert and update

IF :item1 IS NULL
AND :item3 IS NOT NULL THEN
alert_id := FIND_ALERT('blank_alert');
SET_ALERT_PROPERTY(alert_id,ALERT_MESSAGE_TEXT,'Item3 must have a value.');
v_alert := SHOW_ALERT(alert_id);
RAISE Form_trigger_Failure;
END IF;

My problem was as it fires, the cursor will be on the item1. I've already use

SET_ITEM_INSTANCE_PROPERTY
NEXT_ITEM
GO_ITEM

but it was all illegal. The cursor must be in the item3.

Don't question me why I do not set the item3 to required and why post triggers. It is just that. It is the requirement.

View 4 Replies View Related

Forms :: Updating Records Values And Post Trigger

Jul 15, 2013

I have a multi record block based on a view. All records in the view are displayed in the block by use of Post-Query trigger when entering the form.

The block has 5 items as follows:

1) RECORD_STATUS = a non-base table column which is a checkbox.
2) ITEM_TYPE = a text-item which has an LOV attached.
3) ITEM_TEXT = a text-item which is free format text.
4) LAST_UPDATE_DATE a date column
5) STATUS = a text item either 'Open' or 'Closed'

The LOV is based on a table of Item Types with values say, 'Type1', upto 'Type9'.

I have a Wnen-New-Record-Instance trigger which 'Posts' changes to the database. This has been included as i want to limit the values of the ITEM_TYPE column to values which have not been previously used.

Consider this scenario...

The block has 3 records.

record 1 has 'Closed' status so no updates are allowed.
record 2 has 'Open' status so updating of Item_Text is allowed.
record 3 has 'Open' status so updating of Item_Text is allowed.

I check the RECORD_STATUS checkbox on record2.

(This sets the RECORD_STATUS checkbox to a checked value and changes the STATUS column to 'Closed' by When-Checkbox-Changed trigger.) At this point the record has not been saved so if you uncheck the checkbox , then the STATUS column will go back to 'Open'. However at this point i will leave it as Checked (Closed).

I then insert a new record, only values Item4 to Item 9 are correctly shown in the LOV. I select Item4.

I then go back to the previous record and uncheck the Checkbox to say that i wish to leave it 'Open' after all (in effect no changes have occurred), then the STATUS column correctly reverts back to 'Open' by my WCC trigger. If i then SAVE the changes, the new record has been inserted on the database correctly, however the LAST_UPDATED_DATE from the record which was checked and then unchecked has also been updated incorrectly even though no net changes have actually occurred.

(because i am using WNRI trigger to limit the List of Values on the LOV column, this has incorrectly set the previous records LAST_UPDATED_DATE column to be Sysdate.)

How can i stop this from happening?

View 1 Replies View Related

Forms :: Post-INSERT TRIGGER Raised Unhandled Error

Feb 9, 2011

I am facing a post trigger problem.No error while compiling.

DECLARE
mYPACCT VARCHAR2(10);
mTRNNO NUMBER; mVNO NUMBER; mSR NUMBER; mNARRATION VARCHAR2(200); mCHCODE VARCHAR2(10); mPARTY VARCHAR2(200);
mBRAND VARCHAR2(200); mYARN VARCHAR2(200);
BEGIN
BEGIN
SELECT YPACCT INTO mYPACCT FROM CONFIG;
EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
END;

[code].....

View 7 Replies View Related

Forms :: Post-Block Trigger - Trying To Capture Previous Item?

Aug 12, 2010

I have a form w/a tab canvas. BlkA is on Tab1 and Blk2 is on Tab2. In BlkA I have several items that have when-validate-item triggers. However, the trigger does not fire when I enter a value into item1 of BlkA followed by clicking on Tab2. To solve, I placed validate(form_scope) in the When-Tab-Page-Changed trigger. This works well with invoking the validation. However, focus remains on Tab2 (Blk2).

I would like focus to return to failed validation item in Blk1. I can capture the block name using :system.cursor_block in the Post-Block trigger of BlkA, assign that value to a form parameter and when a validation fails via the When-Tab-Page-Changed trigger I can return user back to BlkA(Tab1). However, I need direction on how to return user to the specific item in BlkA that failed validation

View 2 Replies View Related

Forms :: ORA-01403 Value Will Be Sitting According To Post Trigger Of Previous Text Field

Jul 26, 2010

I have sort button that have the following code

go_block('TEL_OTHER_INFO');
set_block_property('TEL_OTHER_INFO',order_by,:system.cursor_item);
execute_query;

I have in the same form display item that its value will be sitting according to the post trigger of the previous text field when i press the sort button i get frm-40735 post-text-item unhandled exception Ora-01403 error.

View 2 Replies View Related

Forms :: To Get X-pos Of Item At Radio-change Trigger

Jun 22, 2013

i want to get the x-pos of item at the radio-change trigger but it return the error

declare
x_pos number;
lnum_x_pos number;
lnum_width number;
begin

if :radio_group = 'E' then
lnum_x_pos := Get_item_property('Remarks',x_pos);
Message('Position of x...'||lnum_x_pos);
lnum_width := get_item_property('Remarks',width);
Message('width of remarks field..'||lnum_width);

else
set_item_property('remarks',enabled,property_true);
set_item_property('remarks',visible,property_true);

end if;
end;

error is:::

argument to built in get_item_property/field char can not be null?

View 1 Replies View Related

Forms :: How To Change Forms Trigger Sequence

Feb 11, 2010

is it possible to change the forms trigger sequence.

for example, i am writing 'when_validate_item' in item level,block level,form level.First item level will fires and then block level and at last form level. But i want to fire the trigger first at form level then block level and at last item level.

View 6 Replies View Related

Forms :: Post Built-in Commits Changes In The Database?

May 7, 2010

I have been testing out a form using 10.1.2.0.2 on a v10.2.0.1 db and in my local env. the form works correctly i.e. if I make a change and 'post' it and then exit and press NO (when asked to save changes) then it correctly leaves the value in the database as it originally was.

The process works by the user pressing a button in form A (read only form) and this opens form B (using open_mode,session,activate) and the user makes their change(s) in form B (a 'post' command is issued in a When New Rec Inst trigger on a db block when the user navigates to a new record within the same block if it is determined that the block status <> 'QUERY') before returning to form A and pressing 'NO' when prompted to save changes.

However, if I run the same process in the TEST env. using the same executable against the same database then it actually updates the database value.

I have tested this by adding a debug message at the end of form B to retrieve the db value back AFTER having issued a clear_form(no_commit) just for the sake of the test and it still returns me the 'new' i.e. amended value - which is obviously incorrect. From what I can see it would appear that the commit occurs straight after the 'post' has been issued and well before the user even exits the form.

Is this a known bug with the 'post' built-in or could it be that a parameter is set to act in this way (i.e. is there an 'autocommit' setting that is 'ON') within the application server?

View 8 Replies View Related

Forms :: How To Delete Record When Saved Through Post Keywords

Aug 6, 2011

i m using oracle 10g forms. in one form i m using post keyword when i use this function then records saved in temporary database but i want to remove one record from this form but it is allrady saved through post.

View 1 Replies View Related

Forms :: Multi Byte Character Post Migration

May 23, 2010

We just migrated our technology platform on one of the six servers yesterday on production d/b as follows :

OAS Server - Linux Patch Applied (2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux)

D/B Server - From Oracle 10.2.0.2.0 to Oracle 10.2.0.4.0
Batch Server - From OpenVMS to Red Hat Linux

Post Migration, we are facing some issues with Oracle Forms 10g, Text Items which contains one or more than one multibyte characters, is displaying only # character in the entire text box instead of what is stored in the database. In other words, information in the database is stored correctly. Before Migration everything was working perfectly fine.

One other thing which I would like to tell here is that we compile forms using the following environment settings:

NLS_LANG_SEMANTICS=CHAR
NLS_LANG=AMERICAN_AMERICA.UTF8

View 9 Replies View Related

Forms :: POST Command - Getting Committed With Error Especially In New Database?

Jul 29, 2010

I have a form which will call another and do some transactions and come back to original form and do other processes. save if successful. or roll back with error message.i m doing POST when i exit from the called form. and continue process in calling form. if any error, i m raising an error message with rollback.

But sometimes, it is getting committed with that error trn. especially in new database, first time try the scenario, it any error comes then getting commited.I m not able to find where the commit is happening? if any other sessions commit will affect this trn?

View 1 Replies View Related

Forms :: FRM-40404 Post Command In Save Procedure To Apply Some Record In Database Temporary

Sep 26, 2011

I am working on form 10g, here i am using post command in save procedure to apply some record in database temporary.

But Frm-40404 Message raise during saving record i need post commond but i dont want to this message should popup, is there any method to avoid the message only?

View 7 Replies View Related

SQL & PL/SQL :: Create Trigger To Change Every Insert In Table To Sysdate

Feb 17, 2011

I have table 'A' with column 'ID','NAME','IN_DATE','PHONE','EMAIL'

Now I have to create a trigger such that on every insert in the table 'A' the value of column 'IN_DATE' changes to sysdate.I m not good in PL/SQL

View 4 Replies View Related

Unable To Change Password In SQLPLUS After Trigger Added

Aug 17, 2012

One of my Customer had followed the document applied pertaining to mitigate against vulnerability CVE-2012-3132.

New Document Mitigation steps for CVE-2012-3132 [ID 1482694.1]

This was applied to a database and it stopped the 'password' command from succeeding in SQLPLUS. Once the trigger was disabled, it worked fine.

ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at "SYS.NAME_SECURITY", line 165
ORA-06512: at line 2

Why is this behavior seen? By the way, he was able to change the password using TOAD. Only sqlplus is the issue.

View 2 Replies View Related

Forms :: Call One Trigger Of Item In Trigger Of Form?

Jul 1, 2011

How can "call one trigger of item in trigger of form"

View 5 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

RAC & Failsafe :: Post Validation Check For New DB

Feb 6, 2013

I have created/added one new RAC database.What post validation check has to be performed after creating new Database.

Note: already there is one DB exist in the server.

View 4 Replies View Related

SQL & PL/SQL :: Calculate Post Arrival Date

May 3, 2011

Find the sample data and table.

CREATE TABLE table_x
( arrival_time VARCHAR2 (8),
post_arrival_time VARCHAR2 (8),
arrival_date date
);
INSERT INTO table_x VALUES ('3:50 PM', '3:50 AM',trunc(sysdate)); -- Post arrival date = trunc(sysdate) - 1
INSERT INTO table_x VALUES ('3:50 AM', '1:00 AM',trunc(sysdate)); -- Post arrival date = trunc(sysdate)
INSERT INTO table_x VALUES ('11:59 AM','11:59 PM',trunc(sysdate)); -- Post arrival date = trunc(sysdate) - 1

Need to calculate Post arrival date .. which will be always < = Arrival date

View 8 Replies View Related

Windows :: How To Get Password Post Installation Of Oracle

Jul 1, 2011

I have installed Oracle 10g on Windows 7 64 bit today by own from the following link with data.

[URL]

1. At the start of my installation

Global Database Name : oracl
Password : my own password

2. At last i got the message "The installation of Oracle Database 10g was successful."

I have tried logon with

User Name as scott with tiger with Host String as oracl
User Name as scott with tiger
User Name as system with manager with Host String as oracl
User Name as system with manager

But i am unable to login to SQL.

Note: In between installation, i have not set any password.

View 7 Replies View Related

Upgrade :: Post Upgradation Steps To Run Scripts

Apr 7, 2013

i upgraded oracle db from 11.2.0.2.0 11.2.0.3.0 on linux using dbua. after completion of the up gradation what are the post upgradation steps. does i need to run any scripts.

View 4 Replies View Related

PL/SQL :: Stored Procedure That Accepts Post Code

Oct 12, 2012

I have to write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive details about each customer, the number of bookings that customer has made and the total cost of all completed rentals for that customer.

The table structure is
custmr - which contains details about the customer
booking - contains detail abut the car booking and its details

View 4 Replies View Related

SQL & PL/SQL :: Display The Current Date With Post Fix Notation In Oracle?

Jul 2, 2013

Is there any way to display the current date with post fix notation in oracle?

Ex : 2nd ,5th , 3rd , 1st , 8th ,

select to_char(sysdate,'DD') from dual;

View 2 Replies View Related

Post Installation Tasks On Oracle 11gR2 On Centos 4.7

Aug 24, 2012

i have installed oracle 11gr2 on centos 4.7,,but after that when i invoke command for startup in sqlplus for sys user it shows an insufficient privileges error. and what are the post installation tasks? is the database installed also?what is the name of database and where is it?

View 5 Replies View Related

Application Express :: DML Not Updating Fields With Post Calculations?

Jan 9, 2013

I am running APEX 4.0.2.I am having an issue where I have a page item that has a post calculation

My source used is "Always..."
My source type is "Database Column"

I have tried putting the code in the page item under "Post Calculation Computation", as a dynamic action, and as a Computation Process. It displays properly on the form no matter where I put the code, but when I select Apply Changes it is not updating the database. What am I doing wrong? I have provided a sample of the code, and yes the column name is in the database.

CASE
WHEN :P12_NUM_OF_BOOKED_DEALS>0 AND :P12_DATE_1ST_COMPLETE IS NULL THEN '(2) In Process'
ELSE '(D1) Open Draft'
END

View 2 Replies View Related

Forms :: How To Change The Name In Run Time

Jul 20, 2010

I would like the change the name in run time find the attachment.

View 3 Replies View Related

Forms :: Change FMX File In Use

Jun 14, 2012

I'm in an environment with Weblogic Oracle Forms 11G (Oracle Fusion Middleware). I can not update a form that is in use. I can not change the fmx file.

Can I change this? Where can I configure this?

View 4 Replies View Related







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