Calling a function/procedure multiple times within a MAP statement
edited Aug 27, 2013 2:21PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi I did a search to see if anybody's encountered this before situation before, but nothing came up so I'm posting the question here.
Here's the idea. I have a function or a stored procedure within the database. Is it possible to call it multiple times to map new columns? I can get it to run for the first call but any further attempts I would get an
OGG-00303 Oracle GoldenGate Delivery for Oracle: Duplicate stored procedure name (
type error
I know I can re-write the procedure to accept two inputs and four outputs as a work-around, but I'd like to see if it's even possible to do what I described above.
Here's the idea. I have a function or a stored procedure within the database. Is it possible to call it multiple times to map new columns? I can get it to run for the first call but any further attempts I would get an
OGG-00303 Oracle GoldenGate Delivery for Oracle: Duplicate stored procedure name (
type error
I know I can re-write the procedure to accept two inputs and four outputs as a work-around, but I'd like to see if it's even possible to do what I described above.
0