1 Reply Latest reply on Mar 23, 2017 6:33 PM by Sherry Lamonica-Oracle

    ROracle package - dbReadTable() error while reading a specific table "OE_ORDER_HEADERS_ALL"

    d473a82e-a39e-44fa-b84a-b1a04202a18d

      Hi All,

      Facing an error while reading the table "OE_ORDER_HEADERS_ALL" using dbReadTable(), the same statement works like a gem for other tables like "OE_ORDER_LINES_ALL" and "WSH_DELIVERY_DETAILS".

       

      Statement: dbReadTable(con, "OE_ORDER_HEADERS_ALL", schema = "APPS")

       

      Error message:

      Error in .oci.GetQuery(con, qry) :

        Error in try({ : embedded nul in string: '\0'

       

      Below are the driver and oracle server version to get to know the context of the error:

       

      Driver details:

      $driverName

      [1] "Oracle (OCI)"

       

      $driverVersion

      [1] "1.3-1"

       

      $clientVersion

      [1] "12.1.0.2.0"

       

      $conTotal

      [1] 1

       

      $conOpen

      [1] 1

       

      $interruptible

      [1] FALSE

       

      $unicode_as_utf8

      [1] TRUE

       

      Oracle Server Details:

      Server version:        12.1.0.1.0

      Server type:           Oracle RDBMS

      OCI prefetch:          FALSE

      Bulk read:             1000

      Bulk write:            1000

      Statement cache size:  0

      Open results:          0

       

      Any help is much appreciated, BTW RODBC package worked well for all the tables through ODBC connection.

      Thanks,

      Srirama