2 Replies Latest reply: Mar 4, 2013 8:41 AM by 992079 RSS

    Error UPDATE PROGRESS Dblink

    992079
      Hello !

      I'd like ask help for this community to discover a problem when oracle try to make a update in Database Progress.


      I configured everythinkg (HS, LISTENER ETC ETC) and Do a select with sucess !


      The problem is when I try some update (SELECT WORK NO PROBLEM)

      UPDATE pub.empresa@dbems2cad cad SET cad.cep = 'TESTE'

      ERROR :

      ORA-00904: "CAD"."CEP": identificador inválido

      I posted a trace file to help analys.



      Oracle Corporation --- SEGUNDA-FEIRA MAR 04 2013 10:14:20.947


      Heterogeneous Agent Release
      11.2.0.2.0




      Oracle Corporation --- SEGUNDA-FEIRA MAR 04 2013 10:14:20.946

      Version 11.2.0.2.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "debug"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
      setting HS_FDS_RECOVERY_PWD to default value
      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
      setting HS_IDLE_TIMEOUT to default of 0
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "UCS2"
      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
      setting HS_FDS_DATE_MAPPING to default of "DATE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      setting HS_FDS_FETCH_ROWS to default of "100"
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_MAP_NCHAR to default of "TRUE"
      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
      setting HS_FDS_QUERY_DRIVER to default of "TRUE"
      setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
      Parameter HS_FDS_QUOTE_IDENTIFIER is not set
      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      Default value of 32 assumed for HS_FDS_SQLLEN_INTERPRETATION
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
      setting HS_FDS_DELAYED_OPEN to default of "TRUE"
      setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
      ORACLE_SID is "ems2cad"
      Product-Info:
      Port Rls/Upd:2/0 PrdStat:0
      Agent:Oracle Database Gateway for ODBC
      Facility:hsa
      Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:ems2cad
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=178
      HOCXU_DRV_NCHAR=1000
      HOCXU_DB_CSET=873
      HS_LANGUAGE not specified
      rc=1000 attempting to get LANG environment variable.
      HOCXU_SEM_VER=112000
      Entered hgolofn at 2013/03/04-10:14:22
      Exiting hgolofn, rc=0 at 2013/03/04-10:14:22
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
      Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
      treat_SQLLEN_as_compiled = 1
      Exiting hgoinit, rc=0 at 2013/03/04-10:14:23
      Entered hgolgon at 2013/03/04-10:14:23
      reco:0, name:sysprogress, tflag:0
      Entered hgosuec at 2013/03/04-10:14:23
      Exiting hgosuec, rc=0 at 2013/03/04-10:14:23
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using sysprogress as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2013/03/04-10:14:23
      HS_FDS_CONNECT_INFO = "ems2cad"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2013/03/04-10:14:23
      dsn:ems2cad, name:sysprogress
      optn:
      Entered hgocip at 2013/03/04-10:14:23
      dsn:ems2cad
      Exiting hgocip, rc=0 at 2013/03/04-10:14:24
      Exiting hgogenconstr, rc=0 at 2013/03/04-10:14:24
      Entered hgolosf at 2013/03/04-10:14:25
      Exiting hgolosf, rc=0 at 2013/03/04-10:14:25
      DriverName:pgoe1025.dll, DriverVer:06.12.0086 (B0127, U0064)
      DBMS Name:OPENEDGE, DBMS Version:10.2B07
      Exiting hgocont, rc=0 at 2013/03/04-10:14:25
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 32 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2013/03/04-10:14:25
      Entered hgoulcp at 2013/03/04-10:14:25
      Entered hgowlst at 2013/03/04-10:14:25
      Exiting hgowlst, rc=0 at 2013/03/04-10:14:25
      SQLGetInfo returns 0x1f for SQL_OWNER_USAGE
      TXN Capable:2, Isolation Option:0xf
      SQLGetInfo returns 32 for SQL_MAX_SCHEMA_NAME_LEN
      SQLGetInfo returns 32 for SQL_MAX_TABLE_NAME_LEN
      SQLGetInfo returns 32 for SQL_MAX_PROCEDURE_NAME_LEN
      SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
      SQLGetInfo returns Y for SQL_COLUMN_ALIAS
      3 instance capabilities will be uploaded
      capno:1989, context:0x00000000, add-info: 0
      capno:1991, context:0x0001ffff, add-info: 0
      capno:1992, context:0x0001ffff, add-info: 0
      Exiting hgoulcp, rc=0 at 2013/03/04-10:14:26
      Entered hgouldt at 2013/03/04-10:14:26
      NO instance DD translations were uploaded
      Exiting hgouldt, rc=0 at 2013/03/04-10:14:26
      Entered hgobegn at 2013/03/04-10:14:26
      tflag:0 , initial:1
      hoi:0x18f05c, ttid (len 20) is ...
      00: 58452E63 30636536 3530612E 342E3136 [XE.c0ce650a.4.16]
      10: 2E333131 [.311]
      tbid (len 17) is ...
      00: 58455B34 2E31362E 3331315D 5B312E34 [XE[4.16.311][1.4]
      10: 5D []]
      Exiting hgobegn, rc=0 at 2013/03/04-10:14:26
      Entered hgodtab at 2013/03/04-10:14:26
      count:1
      table: PUB.EMPRESA
      Allocate hoada[0] @ 03C7CC84
      Entered hgopcda at 2013/03/04-10:14:26
      Column:1(ep-codigo): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:26
      Entered hgopcda at 2013/03/04-10:14:26
      Column:2(nome): dtype:12 (VARCHAR), prc/scl:140/0, nullbl:0, octet:140, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:26
      Entered hgopcda at 2013/03/04-10:14:26
      Column:3(razao-social): dtype:12 (VARCHAR), prc/scl:80/0, nullbl:0, octet:80, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:26
      Entered hgopcda at 2013/03/04-10:14:27
      Column:4(endereco): dtype:12 (VARCHAR), prc/scl:70/0, nullbl:0, octet:70, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:5(cep): dtype:12 (VARCHAR), prc/scl:24/0, nullbl:0, octet:24, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:6(cidade): dtype:12 (VARCHAR), prc/scl:50/0, nullbl:0, octet:50, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:7(uf): dtype:12 (VARCHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:8(cgc): dtype:12 (VARCHAR), prc/scl:38/0, nullbl:0, octet:38, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:9(inscr-estad): dtype:12 (VARCHAR), prc/scl:38/0, nullbl:0, octet:38, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:10(usa-reduzida): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:11(encer-semest): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:27
      Entered hgopcda at 2013/03/04-10:14:27
      Column:12(prim-pg-diar): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:13(ult-pg-diar): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:14(prox-pg-diar): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:15(ct-luc-perda): dtype:12 (VARCHAR), prc/scl:16/0, nullbl:1, octet:16, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:16(sc-luc-perda): dtype:12 (VARCHAR), prc/scl:16/0, nullbl:1, octet:16, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:17(ultima-reduz): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:18(apur-luc-per): dtype:-7 (BIT), prc/scl:1/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:19(moeda-fasb): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:20(tab-prev-inf): dtype:12 (VARCHAR), prc/scl:14/0, nullbl:1, octet:14, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:21(cd-termo-abe): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:22(cd-termo-enc): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:23(moeda-BTN): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:28
      Entered hgopcda at 2013/03/04-10:14:28
      Column:24(tp-variacao): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:25(mo-monetaria): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:26(contab-estat): dtype:12 (VARCHAR), prc/scl:54/0, nullbl:0, octet:54, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:27(ins-municipal): dtype:12 (VARCHAR), prc/scl:38/0, nullbl:1, octet:38, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:28(cmi-prim-ult): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:29(data-inicio): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:30(data-fim): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:31(ano-corrente): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:32(moeda-orcam): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:29
      Entered hgopcda at 2013/03/04-10:14:29
      Column:33(Endereco-2): dtype:12 (VARCHAR), prc/scl:80/0, nullbl:1, octet:80, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:34(e-mail): dtype:12 (VARCHAR), prc/scl:80/0, nullbl:1, octet:80, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:35(home-page): dtype:12 (VARCHAR), prc/scl:80/0, nullbl:1, octet:80, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:36(bairro): dtype:12 (VARCHAR), prc/scl:60/0, nullbl:1, octet:60, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:37(conta-lucros-perdas): dtype:12 (VARCHAR), prc/scl:34/0, nullbl:1, octet:34, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:38(pais): dtype:12 (VARCHAR), prc/scl:40/0, nullbl:1, octet:40, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:39(niv-mais-bai): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:40(char-1): dtype:12 (VARCHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:41(char-2): dtype:12 (VARCHAR), prc/scl:200/0, nullbl:1, octet:200, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:42(dec-1): dtype:2 (NUMERIC), prc/scl:23/8, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:43(dec-2): dtype:2 (NUMERIC), prc/scl:23/8, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:30
      Column:44(int-1): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:30
      Entered hgopcda at 2013/03/04-10:14:31
      Column:45(int-2): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:46(log-1): dtype:-7 (BIT), prc/scl:1/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:47(log-2): dtype:-7 (BIT), prc/scl:1/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:48(data-1): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:49(data-2): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:50(cod-imagem-emp): dtype:12 (VARCHAR), prc/scl:60/0, nullbl:1, octet:60, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:51(telefone): dtype:12 (VARCHAR), prc/scl:64/0, nullbl:1, octet:64, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:52(check-sum): dtype:12 (VARCHAR), prc/scl:40/0, nullbl:1, octet:40, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      Entered hgopcda at 2013/03/04-10:14:31
      Column:53(endereco_text): dtype:12 (VARCHAR), prc/scl:4000/0, nullbl:1, octet:4000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2013/03/04-10:14:31
      The hoada for table PUB.EMPRESA follows...
      hgodtab, line 1092: Printing hoada @ 03C7CC84
      MAX:53, ACTUAL:53, BRC:1, WHT=6 (TABLE_DESCRIBE)
      hoadaMOD bit-values found (0x200:TREAT_AS_CHAR,0x20:NEGATIVE_HOADADTY)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      4 INTEGER N 4 4 0/ 0 0 0 0 ep-codigo
      12 VARCHAR N 140 140 0/ 0 0 0 200 nome
      12 VARCHAR N 80 80 0/ 0 0 0 200 razao-social
      12 VARCHAR N 70 70 0/ 0 0 0 200 endereco
      12 VARCHAR N 24 24 0/ 0 0 0 200 cep
      12 VARCHAR N 50 50 0/ 0 0 0 200 cidade
      12 VARCHAR N 8 8 0/ 0 0 0 200 uf
      12 VARCHAR N 38 38 0/ 0 0 0 200 cgc
      12 VARCHAR N 38 38 0/ 0 0 0 200 inscr-estad
      -7 BIT N 1 1 0/ 0 0 0 20 usa-reduzida
      -7 BIT N 1 1 0/ 0 0 0 20 encer-semest
      4 INTEGER N 4 4 0/ 0 0 0 0 prim-pg-diar
      4 INTEGER N 4 4 0/ 0 0 0 0 ult-pg-diar
      4 INTEGER N 4 4 0/ 0 0 0 0 prox-pg-diar
      12 VARCHAR Y 16 16 0/ 0 0 0 200 ct-luc-perda
      12 VARCHAR Y 16 16 0/ 0 0 0 200 sc-luc-perda
      4 INTEGER Y 4 4 0/ 0 0 0 0 ultima-reduz
      -7 BIT Y 1 1 0/ 0 0 0 20 apur-luc-per
      4 INTEGER N 4 4 0/ 0 0 0 0 moeda-fasb
      12 VARCHAR Y 14 14 0/ 0 0 0 200 tab-prev-inf
      4 INTEGER Y 4 4 0/ 0 0 0 0 cd-termo-abe
      4 INTEGER Y 4 4 0/ 0 0 0 0 cd-termo-enc
      4 INTEGER N 4 4 0/ 0 0 0 0 moeda-BTN
      4 INTEGER N 4 4 0/ 0 0 0 0 tp-variacao
      4 INTEGER N 4 4 0/ 0 0 0 0 mo-monetaria
      12 VARCHAR N 54 54 0/ 0 0 0 200 contab-estat
      12 VARCHAR Y 38 38 0/ 0 0 0 200 ins-municipal
      4 INTEGER Y 4 4 0/ 0 0 0 0 cmi-prim-ult
      91 DATE Y 16 16 0/ 0 0 0 0 data-inicio
      91 DATE Y 16 16 0/ 0 0 0 0 data-fim
      4 INTEGER Y 4 4 0/ 0 0 0 0 ano-corrente
      4 INTEGER Y 4 4 0/ 0 0 0 0 moeda-orcam
      12 VARCHAR Y 80 80 0/ 0 0 0 200 Endereco-2
      12 VARCHAR Y 80 80 0/ 0 0 0 200 e-mail
      12 VARCHAR Y 80 80 0/ 0 0 0 200 home-page
      12 VARCHAR Y 60 60 0/ 0 0 0 200 bairro
      12 VARCHAR Y 34 34 0/ 0 0 0 200 conta-lucros-perdas
      12 VARCHAR Y 40 40 0/ 0 0 0 200 pais
      4 INTEGER Y 4 4 0/ 0 0 0 0 niv-mais-bai
      12 VARCHAR Y 200 200 0/ 0 0 0 200 char-1
      12 VARCHAR Y 200 200 0/ 0 0 0 200 char-2
      3 DECIMAL Y 26 26 23/ 8 0 0 0 dec-1
      3 DECIMAL Y 26 26 23/ 8 0 0 0 dec-2
      4 INTEGER Y 4 4 0/ 0 0 0 0 int-1
      4 INTEGER Y 4 4 0/ 0 0 0 0 int-2
      -7 BIT Y 1 1 0/ 0 0 0 20 log-1
      -7 BIT Y 1 1 0/ 0 0 0 20 log-2
      91 DATE Y 16 16 0/ 0 0 0 0 data-1
      91 DATE Y 16 16 0/ 0 0 0 0 data-2
      12 VARCHAR Y 60 60 0/ 0 0 0 200 cod-imagem-emp
      12 VARCHAR Y 64 64 0/ 0 0 0 200 telefone
      12 VARCHAR Y 40 40 0/ 0 0 0 200 check-sum
      12 VARCHAR Y 4000 4000 0/ 0 0 0 200 endereco_text
      Exiting hgodtab, rc=0 at 2013/03/04-10:14:33
      Entered hgodafr, cursor id 0 at 2013/03/04-10:14:33
      Free hoada @ 03C7CC84
      Exiting hgodafr, rc=0 at 2013/03/04-10:14:33
      HS Agent received unexpected RPC disconnect
      Network error 1003: NCR-01003: NCRS: Erro na leitura.
      Entered hgoroll at 2013/03/04-10:15:44
      tflag:0 , cmt(38):Unexpected EOF from Oracle - Rollback
      hoi:0x3c63c10, ttid (len 20) is ...
      00: 58452E63 30636536 3530612E 342E3136 [XE.c0ce650a.4.16]
      10: 2E333131 [.311]
      tbid (len 17) is ...
      00: 58455B34 2E31362E 3331315D 5B312E34 [XE[4.16.311][1.4]
      10: 5D []]
      Entered hgocpctx at 2013/03/04-10:15:44
      Exiting hgocpctx, rc=0 at 2013/03/04-10:15:45
      Exiting hgoroll, rc=0 at 2013/03/04-10:15:45
      Entered hgolgof at 2013/03/04-10:15:45
      tflag:0
      Exiting hgolgof, rc=0 at 2013/03/04-10:15:45
      Entered hgoexit at 2013/03/04-10:15:45
      Exiting hgoexit, rc=0
        • 1. Re: Error UPDATE PROGRESS Dblink
          Mkirtley-Oracle
          Hi,
          it looks like you have the wrong syntax for the update statement.
          You have -

          UPDATE pub.empresa@dbems2cad cad SET cad.cep = 'TESTE'

          What happens if you send it as -

          UPDATE pub.empresa@dbems2cad cad SET cep = 'TESTE' ;

          or as -

          UPDATE pub.empresa@dbems2cad cad SET "cep" = 'TESTE' ;

          Is Progress case sensitive for object names ?

          Regards,
          Mike
          • 2. Re: Error UPDATE PROGRESS Dblink
            992079
            UPDATE pub.empresa@dbems2cad cad SET "cep" = 'TESTE' ;



            Worked to me !


            Just wondering, are there a way to dblink put automaticaly "" in field cep to avoid change my update statment ?

            Thanks man !

            Edited by: 989076 on 04/03/2013 06:40