Skip navigation
Contact Us
991 Views 6 Replies Latest reply: Nov 15, 2012 6:27 PM by Viral Raichura RSS
Jeff Vendetti Newbie 4 posts since
Nov 12, 2012
Currently Being Moderated

Nov 12, 2012 11:28 AM

Using SQL in a Java Transformation

Hi, All

 

I'm trying to use SQL within a Java transformation, something like "SELECT SEQUENCE_NAME.nextval FROM DUAL".  I will need to call it multiple times (up to a few thousand times) in order to synchronize sequences from one environment to another.  Although I have completed a small stored procedure, I would like to do it entirely within a mapping without the stored procedure.  Any ideas how to approach this?

 

Thanks.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points