Retrieve active users in Oracle Applications
retrieve currently active and valid fnd user from oracle applications
Archive for the ‘PL/SQL’ Category
Split String using Oracle PL/SQL
Oracle PL/SQL provides various string functions, but there is no direct function to split a string into substrings, we need to write a custom code to do this task.
How to know Request Group name of Concurrent Programs in Oracle Applications
knowing request group name to which a concurrent program is associated helps in oracle apps…..
How to Find concurrent programs associated with responsibility in Oracle Applications
Know concurrent programs associated with responsibility using responsiblity key
File contents into BLOB in Oracle Database, using PL/SQL
Often there will be a requirement for reading .out files generated by Oracle Applications and converting into pdf files and send as mail attachment. Here is a sample PL/SQL procedure which can read a file from a specified location, into a BLOB and returns it. The calling program can convert this blob data [...]
