Skip to Content
Former Member
Jul 17, 2006 at 03:46 PM

Oracle Extraction


Hi All

Iam extracting data from Oracle views. There is a field declared as varchar in oracle and mapped to CHAR field in BW.

This particular field consists data as alpha, alphanumeric and only numeric ['ABC', 'AB1234', '1234' etc.,] Records with alpha and alphanumeric fields are extracted and posted into PSA and gives error while extracting records with only numeric values ['1234'].

How do we solve this issue? Thanks in advance for the reply.