LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  DB Query node not executing Select * command

    Employee
    Posted 05-27-2015 03:43

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gauravdb

    Hi,

    I am having a weird issue with "DB Query" node. Whenever I write Select * from test_table, I receive the following message:

    Lavastorm Database error : OCI Error 1406: ORA-01406: fetched column value was truncated

    But if I write names of columns instead of *, then it works fine.

    Can anyone help on this issue please.

    Thanks
    GK


  • 2.  RE: DB Query node not executing Select * command

    Employee
    Posted 12-09-2015 05:11

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mgajdosik

    Did you try to execute the very same statement from some oracle client, like Toad or similar, if you get the same error?

    Also you may want to do following:
    Check out your Oracle table definition. You can declare Oracle column types to be just NUMBER, but this is bad practice as you are then dependent on your target client to sort this out. You should really always give it precision (e.g. NUMBER(18,7))