Sitemap

Amicuk Programming Answers

How to re-calculate a column value based on another column value in the same ADF Table row

2015-10-11   Views:6

Advertisement

Hi, I'm using Jdeveloper 11.1.2.3.0. I have an adf table with 2 columns, columnA and columnB. When the value changed in ColumnA, 1) i need to call a PLSQL and update the ColumnB value that is returned from PLSQL. 2) Show a warning message if the exis

Hi,
I'm using Jdeveloper 11.1.2.3.0.
I have an adf table with 2 columns, columnA and columnB.
When the value changed in ColumnA,
1) i need to call a PLSQL and update the ColumnB value that is returned from PLSQL.
2) Show a warning message if the existing value in ColumnB is different from the one that is returned from PLSQL.
Can anybody suggest how can i accomplish this?
Thanks,
Vinod

The replay answer
Advertisement
hi user,
if you have inputtext means have a valuechangelistener
in that call your pl/sql function supply input value to the appropriate function then grab the result of the function. then bind the column inputtext and compare with it. then raise your warning using FacesMessage classes.
Sameh Nassar: Create PL/SQL Function And Call It From Your ADF Application

Go to See the other 4 answers

Hot
Hi, I have some questions on using InfoBus Frame. Do parent frame and child frame HAVE TO make use the same SessionInfo object? I tried to show Master table and Detailed table in seperate frame without login twice. I am lucky it works since I happene [More]
Hi, I have created a table, at a time 20 records are displayed in the table. When the 21-40 records are displayed in the table, and the page is refreshed.. then first 20 records are displayed. How can I display the current records i.e., 21-40 records [More]
This is our main printer in the design area at work and I really need this to work!!  Any help appreciated. Vista SP2 Dell Pavilion Intel Quad 2.33ghz 64bit OS 8gb RAM OfficeJet Pro K8600 on USB cable to main ports I loose the connection and have to [More]
I have created one po order for which I am getting the error as"control indicators for controlling area donot exist" Can some body tell me me how to solve ths issue and wt settings needs to be done in IMG Regards ChitraGo to OKKP Transaction cod [More]
When browsing artists (Ctrl+B) in iTunes, "Jay-Z" and "Jay-Z Ft. MJB" sort different, even thought they both have the same album artist. When selecting "Jay-Z Ft. MJB" only one song appears. So I tried entering Jay-Z as " [More]
I'm doing Java development on the recently released 10.7. Everything's working fine until I try to run a Java command-line program that makes use of Swing facilities internally. The command-line program uses JasperReports and JasperReports is attempt [More]
I'm using the WRE54G unit and I cannot connect to the unit.  I have connected it to my computer using a cat5 cable but I still cannot connect to the setup page.  Right now I'm getting one solid light.  I started trying to connect to the unit when my [More]
I installed war file on the web logic server,after step 1,I press 'servicing all request' button for starting. unfortunately,I must repeat these action every time.The Application Server does not start project automatically. My WebLogic Application ve [More]
Hello, I had to reinstall my PC at home and at the office. Both times, connecting the ipod, the PC asked me to "allow" this new computer, this means I am only using 2 PCs but they count for 4. For what? I haven't really understood this. Can anyb [More]
''Duplicate post, continue here - [/questions/769164]'' Will this mess up Ff?The files that were in the \components\ folder in 3,6 and previous versions are in the Firefox 4 program files '''omni.jar''' file from what I have read and have seen. I don [More]