Hi,

I'm trying to use the DatabasePipe command in the new 2.2 version to put data from an Access database into a Oracle 8i database. The DatabasePipe command runs and returns the correct number of rows but when I query the table in Oracle, it shows no updates.

I've also tried going from Access to Access and again, it returns the correct number of rows, but I see no data in the table. Here's my code:

DatabasePipe("GatewayReporting", &

"OADD Oracle", &

"Select * from [4 Ph and Order Tbl 5/15]", &

"SalesRepInfoStage", &

"INSERT", &

rows)

Try "UPDATE" and also make "SalesRepInfoStage" have a primary key or a unique index.

: Hi,

: I'm trying to use the DatabasePipe command in the new 2.2 version to put data
: from an Access database into a Oracle 8i database. The DatabasePipe
: command runs and returns the correct number of rows but when I query the
: table in Oracle, it shows no updates.

: I've also tried going from Access to Access and again, it returns the correct
: number of rows, but I see no data in the table. Here's my code:
: DatabasePipe("GatewayReporting", &

: "OADD Oracle", &

: "Select * from [4 Ph and Order Tbl 5/15]", &

: "SalesRepInfoStage", &

: "INSERT", &

: rows)

: Try "UPDATE" and also make "SalesRepInfoStage" have a
: primary key or a unique index.

We do have an index on the table. I can try the UPDATE but we will be truncating the table and doing clean inserts for the batch job. We're using Oracle 8.1.5.5 dll. Don't know if that makes a difference.

-sb

Thanks for the info, I contacted tech.support guys and they say they found some bug in third party component used in 24x7. They are working with on the fix.

: We do have an index on the table. I can try the UPDATE but we will be
: truncating the table and doing clean inserts for the batch job. We're
: using Oracle 8.1.5.5 dll. Don't know if that makes a difference.

: -sb