Hello Guys,
I am having a problem with the user tokens in golden gate.
I cannot find any documentation or someone who experienced a similar issue. The problem that I have is that all my user tokens become null after I use them in a query.
My extract looks like this:
TABLE table1, FILTER(#UPD()),
SQLEXEC(id q_id,
QUERY #q_test(),
PARAMS (#p_test())),
TOKENS (#t_test());
My macros file looks like this:
MACRO #q_test
BEGIN
"SELECT
:p1 as param_1,
:p2 as param_2,
....
:p12 as param_12
from dual"
END;
MACRO #p_test
BEGIN
p1=col1,
p2=col2,
...
p12=col12
END;
MACRO #t_test
BEGIN
t_1=@GETVAL(q_test.param_1),
t_2=@GETVAL(q_test.param_2),
...
t_12=@GETVAL(q_test.param_12),
END;
All my user tokens are NULL, therefore I tried commenting out all parameters and enabling one by one.
It works, the token have values, until I reach the sixth or seventh parameter, it's random then all tokens are set to null again.
That's why I'm wondering if there is a limit in the number of parameters or the size of them.
Thanks in advance for your help.
P.S. The query is more complicated than that, I used and example to show my issue.
Thanks,