Hi, i currently build an application using Lucee Hosting provides by HostSinimo. i need a little help on my coding. How to get current oracle sequence number for insert query in one page? Example this is my insert statement
<CFQUERY NAME=”INSERT” DATASOURCE=”MYSOURCE”>
INSERT INTO TABLE (REF_ID,DESC) VALUES (TABLE_SEQ.NEXTVAL,’TESTING’)
I want to get current sequence number
can anyone help me regarding this?