The following code will query some data from the Oracle Database and will export them on a CSV file. The webserver where this script is executed should have the OCI8 library installed. The execution of this script can be also scheduled to have a periodic backup of a certain table. The script below will extract […]

Sometimes it’s needed to send an email using PL/SQL. This can be done with few lines of code pasted below. The variables $server.address, $domain, $sender_email, $recipient_email should be replaced with the relevant information. DECLARE l_retVal INTEGER; v_connection UTL_SMTP.connection; BEGIN v_connection := UTL_SMTP.open_connection(‘$server.address’); UTL_SMTP.helo(v_connection, ‘$domain’); UTL_SMTP.mail(v_connection, ‘$sender_email’); UTL_SMTP.rcpt(v_connection, ‘$recipient_email’); UTL_SMTP.open_data(v_connection); UTL_SMTP.write_data(v_connection, ‘From: $sender_email’ || UTL_TCP.crlf); UTL_SMTP.write_data(v_connection, […]

After 2 weeks of holiday… I finally wrote the script that automate the transfer of one or more form personalization from an environment to another. This script will take in input the function names associated to each form personalization, will download the *.ldt files and will create the installation script to be executed on […]

Sometimes it’s needed to check what a user can do in the system. The script functions_x_user.sql can be customized to know which function a user can access. If you find it useful don’t forget to leave your comment!

Before to set an end date to a user account, it always worth to check if there are scheduled concurrent programs assigned. The script scheduled_programs.sql can be customized to get which users have scheduled the same program or which programs have been scheduled by a single user. If you find it useful do not forget […]

In case of issues, a System Administrator needs to know what a user has done in the system. The script forms_used_by_user.sql gives in output the forms that have been used and for how long. If you find it useful do not forget to leave your comment!