retrive active users in oracle applications
retrieve currently active and valid fnd user from oracle applications
Archive for the ‘Oracle Database’ 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.
Know request group name of concurrent programs
knowing request group name to which a concurrent program is associated helps in oracle apps…..
find concurrent programs associated with responsibility
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 into any form.
Calling program [...]
