Oracle Enterprise stage

santoshkumar · Post by **santoshkumar** » Mon Nov 13, 2006 7:08 pm

Hi,

I am running a job where source is oracle and target is oracle.
My source contain user defined SQL where i perform left outer join and based on a filter condition in tranformer i move data to target oracle table(truncate and load)

job is aborting with below error message.There are total 6 columns 4( 2 are nullable) are character fields and 2 are date fields.

Code: Select all

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema type "ustring": Max length must be positive, got: "0"
Could not find type: ustring[max=0]

Any help is appreciated

ray.wurlod · Post by **ray.wurlod** » Mon Nov 13, 2006 9:37 pm

Somewhere in your Columns definitions, somewhere in the job (not necessarily in the Oracle Enterprise stage) you have a VarChar data type with no (=zero) precision. This is illegal.

string[max=n] is the Orchestrate Framework's way of representing VarChar(n) in a schema.

keshav0307 · Post by **keshav0307** » Tue Nov 14, 2006 6:01 am

check the column name , type and length of the query and the output schema of the oracle stage; it should be same.