1 Reply Latest reply: Mar 11, 2012 10:43 PM by 885094 RSS

    joining a table using golden gate get the fallowing error in data pump file

    923120
      ***********************************************************************
      ** Run Time Messages **
      ***********************************************************************

      Opened trail file /opt/app/t1sdp1f52/ggsoraarch01/etrail/lt000073 at 2012-03-11 17:36:50
      TABLE resolved (entry CMADMIN.CCE_TEST3):
      TABLE CMADMIN.CCE_TEST3, SQLEXEC ( ID my_table2,QUERY ("SELECT F2 ,F3 FROM CMADMIN.CCE_TEST4 where f2 =:vkey" ), params( vkey = CC
      E_TEST3.F2)),TOKENS ( tk_field1 = @GETVAL(my_table2.F3));

      Source Context :
      SourceModule : [er.sp]
      SourceID : [$Id: sp.c st_ogg_zluo_mlr_backport_12748573_10.4.0.0.0/1 2011/07/12 19:07:11 zluo Exp $]
      SourceFunction : [SP_parse(char *, sp_def **, file_def *, char *, const void *)]
      SourceLine : [471]

      2012-03-11 17:36:50 GGS ERROR 101 Error in SQLEXEC clause, id my_table2: Invalid parameter name: vkey.
      i am using the fallowing code to query and another table and attach the results the table to captured other side

      ---9. Specify tables to be captured
      TABLE CMADMIN.CCE_TEST3 ,SQLEXEC ( ID my_table2,&
      QUERY ("SELECT F2 ,F3 FROM CMADMIN.CCE_TEST4 where f2 =:vkey" ), params( vkey = CCE_TEST3.F2)),&
      TOKENS ( tk_field1 = @GETVAL(my_table2.F3));