I am using OWB 11 with Oracle 11 and am hitting an error on something I would think is super simple in expression builder!
So I been reading around the forums and havent been able to figure out what is going on with my transformation
I drag and dropped the transformation "Anydata Cast" onto my mapping
I select the target type as "VARCHAR" for casting
I drag and drop the source column and drop it over the auto generated "CAST_SOURCE" from INGRP1
I then drag CAST_TARGET from the OUTGRP1 to my target
I right click the ANYDATA_CAST transformation and click on "Output Attributes" and click on the "..." to open the expression builder
Then I input the following code
CAST( INGRP1.CAST_SOURCE AS VARCHAR(10))
And hit validate
I then hit the following error
Line 1, Col 40:
PLS-00103: Encountered the symbol "(" when expecting one of the following:
. ) @ %
Am I missing something in my code??
I know this is really simple, but I really cant find what I am doing wrong??
Thanks in advance