Hi,
Can someone help to fix below failure. -
I have a failing extract with below lines to capture one column table1col1 of table table1 and run a stored procedure sp1 with param sp1_param1 to which I am passing value of table1col1 .
TABLE owner1.table1, COLS (table1col1);
SQLEXEC (SPNAME owner1.package1.sp1 , &
PARAMS (sp1_param1 = table1col1))
Manual run works for EXEC owner1.package1.sp1(2000041);
But in gg it-extract fails stops with below error -
Golden gate (ORA-00900: invalid SQL statement SQL SPNAME owner1.package1.sp1 , PARAMS (sp1_param1 = table1col1))
There is no replicat.