Yes! We all know that cannot use SQLCODE, SQLERRM in INSERT Statement! but why?? SQLCODE, SQLERRM are predefined functions which are useful in Exception handling.… Read More »Why cant we use SQLERRM and SQLCODE in INSERT Statement?
I had a requirement to validate date entered in a free text field (standard field on a standard form). I have solved it by writing… Read More »Date Format validation on Standard Free Text Fields
Usually in seeded objects definition we see the key words AUTHID CURRENT_USER or AUTHID DEFINER like shown in the below screen shot AUTHID clause tells… Read More »AUTHID CURRENT_USER and AUTHID DEFINER
There are many ways to generate output in XML tags format, dbms_xmlgen is one of the way to generate. Lets consider an example to display… Read More »PL/SQL Script to Generate XML Tags for XMLP Report
Oracle has provided an API UTL_SMTP which can be used to send email from PL/SQL. UTL_SMTP uses SMTP (Simple Mail Transfer Protocol) sever to send… Read More »UTL_SMTP API to send HTML Emails from PL/SQL
Have you ever tried to find out the database name or instance name without having access to data dictionary views? How to get the client… Read More »Oracle SYS_CONTEXT Function in PL/SQL
Errbuf and Retcode are two OUT type mandatory parameters used in PL/SQL procedures which are called through concurrent requests. Purpose of Errbuf and Retcode Paramters?… Read More »Information on Errbuf and Retcode Parameters
fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Added some logic to select responsibilities of one user to another user.… Read More »Oracle Script to Copy Responsibilites of one user account to another user account
Oracle has a seeded API fnd_user_pkg which has a procedure createuser which is used to create a user login account. Below is the sample script… Read More »Oracle Script to Create User Login Account