DBMS_SESSION.RESET_PACKAGE

select s,
substr(s, nullif( instr(s,'.', -1) +1, 1) )
from (
select 'no_extension_should_return_null' s from dual union
select 'another.test.1' from dual union
select 'another.test.doc' from dual union
select 'another.test.docx' from dual union
select 'another.test.stupidlng' from dual
)

Refer the code provided in the link below:

http://www.lkakarla.com/2012/09/get-file-from-ucm-using-ridc-client.html

Just add the following line in the above code:

dataBinder.putLocal("Rendition","Alternate");

This is how it should appear:

dataBinder.putLocal("IdcService", "GET_FILE");

dataBinder.putLocal("Rendition","Alternate");

I have looked and have been unable to find an answer to the following challenge I am having. It seems pretty straightforward but I have been unable to resolve it. I have an ArrayList of record id...

select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual