Bind references are used to replace a single value in SQL or PL/SQL. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING,CONNECT BY, and START WITH clauses of queries. Binds may not be referenced in the FROM clause.An example is:SELECT Col1,Col2FROM XX_tableWHERE Col1 = :P_col1 Lexical references […]
If your program is taking time to complete, then the best way to know what is causing the problem is by creating a trace file. Navigation: System Administrator(R) –> Concurrent –> Program –> Define Query for the concurrent program and check enable trace button. Now when the concurrent program is executed the trace file is […]
On apps there are a lot of profile options that are useful in making apps passwords difficult to guess, the profiles are 1-Signon password failure limit2-Signon Password Length3-Signon Password No Reuse4-Signon Password Hard to Guess For the first one it means how many time can I try to access the system using wrong password. It […]
The PL/SQL Wrap Utility – Hide source code in Oracle A company has a code(Package, Procedure, Function etc) with all the proprietary information and logic in it. If this information is leaked out in the market then the competitors can take advantage of it and this can affect the business. One of the way to […]
On request here is how to set the profile option value using PL/SQL Function FND_PROFILE.SAVE can be used to set the value of any profile option at any level i.e. Site, Application, Responsibility, User etc. Below is a sample code of how to use this function DECLARE a BOOLEAN;BEGIN a := fnd_profile.SAVE (‘CONC_REPORT_ACCESS_LEVEL’ […]
Recent Comments