iStore - EBS (MOSC)

MOSC Banner

How to insert sequence_name.nextval where sequence_name is stored in string.

edited Jun 19, 2015 5:45AM in iStore - EBS (MOSC) Question

Hi,

We have arequirement to insert a new a sequence depending on orgid.so how to use the string variable for sequence name in jdbc to insert value in the system.

This is working fine plsql. But how to use the same in jdbc.

seqnam='AEPL_DEALER_CLAIM_Num_S'||'.nextval';

'select '||seqnam||'.nextval from dual' into a ;

Please help

Thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center