Tutor for ADF developers

http://www.docstoc.com/docs/6245714/Oracle-ADF-Tutorial

ORACLE APPS TRAINING, STRUCTUR AND PRACTIVE

Get registred on http://vis1211.solutionbeacon.net for the practive of Oracle ERP.
We can findout lot of materail for Oracle ERP http://etrm.oracle.com by getting registration on it.

SQL%NOTFOUND

Don't use this inside the for loop LIKE FOR
FOR i IN (SELECT sch_id,CURDATE FROM ORDERS)
LOOP
DON'T USE(EXIT WHEN SQL%NOTFOUND);

Use of NOCOPY with Oracle Function and Procedures.

• NOCOPY will instruct Oracle to pass the argument as fast as possible. This can significantly enhance performance when passing a large value.

• Ussually IN paramter is pass by value and OUT/IN OUT are pass by refererence....

If one wants to send the IN paramter too as pass by reference he could add NOCOPY
parameter....

advantage is always less memory usage

disadvantage is when there is a change happened to the Reffered value and a rollback occurs in the procedure the change of value would be retained.... it could not be rolled back....

so I beleive that it is always safe to work without the NOCOPY parameter.....