Skip to Content

How to load date field from a remote Oracle DB with DB Connect

Hi,

Does any one have experience extracting Date field from a remote Oracle database through DB Connect to BW? I am experiencing data format issue. The extracted data shows '04-Oct-0' for '10/4/05'. It works fine if I create a view in Oracle database to preformat the data to '20051004'. But, I am not allowed to create view in Remote DB.

Any suggestion is very appreciated.

Regards,

Frank

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 05, 2005 at 08:16 PM

    You have to change it to a varchar2 field. YYYYMMDD. I do not know of any other option.

    Add comment
    10|10000 characters needed characters exceeded