Recently I faced an issue in Adf application. The .jspx page giving null pointer exception after doing some operation in page. And every variable have contain their value. I have try to run application many time in debug mode to replicate the problem but not able to find. Then I find in ADF application when [...]

In Oracle Adf we will doing DML operation by calling the Procedure.Here the syntax of calling Stored procedure is as follow:

In oracle adf, To enable to scrollbar In .jspx page. we need to right click on .jspx .Go to page definition of file .Go to particular iterator of which you have created the table. The iterator tag will be in executable tag.In iterator tag go to rangesize.And change the rangesize to “-1″ from “10″ like [...]

DECODE Decode function has the functionality of an IF-THEN-ELSE statement. Decode does a value-by-value substitution. For every value that is given in the DECODE function it makes if then check and matches the value. Syntax-Decode (Value, if-search-1,result1,if-search-2,result2,if-search-3,result3,if-search-1,default-result) Example select empname,Decode(empid,1001,20000,1002,12000,1003,15000,null) from emp; This query is selecting the emp name and salary on basis of emp [...]

PPR is Partial Page Rendering, similarly to Ajax. It is used to dynamically refresh the part of page.It is done with the use of partial triggers. For better understanding , i will explain by an example. In Any .jspx page we have one table (table1) and one command button(button1) label ‘Delete’. On clicking the Delete [...]

OAF versus ADF I have seen many forums asking about Difference between OAF and ADF. May be my post will clear some points on this OAF – OAF is a framework for extending Oracle E-Business Suite. If you want to customize and Oracle EBS system you need to use OAF. OAF is a e-biz web [...]

In mysql user need permission based on IP to connect mysql server. In default installation of mysql it doesn’t permit root to connect from remote machine Using the following command, we set permission for connecting server from remote machines shell> mysql –user=root mysql mysql>GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY ‘some_pass’ WITH GRANT [...]