Unrecognized argument: HH24:MI:SS.FF) in oracle stage

parilango · Post by **parilango** » Thu Jun 23, 2016 8:50 am

when i pass the query as parameter to the oracle stage I am getting these error. could you please help

Unrecognized argument: HH24:MI:SS.FF) in oracle stage

db_TGT_STG: SAX parser exception thrown: The input ended before all started tags were ended. Last tag started was 'InsertStatement' (CC_PropertySet::fatalError, file CC_PropertySet.cpp, line 2234)

chulett · Post by **chulett** » Thu Jun 23, 2016 9:35 am

So... the connector is being used as a source and you are passing in the entire SELECT statement as a parameter? I'd be very curious as to the why of that but let's start with you posting the parameter value. We'll also need to know how well that lines up with the columns defined in the stage.

parilango · Post by **parilango** » Thu Jun 23, 2016 9:46 am

source is ODBC connector we select the source data and oracle connector is the target where we insert the data. we pass the insert query through parameter since we are using the same for to load 10 tables each will have different columns. so select and insert query are parameters. Thanks for your quick response

chulett · Post by **chulett** » Thu Jun 23, 2016 10:12 am

That sounds like something you should be using RCP for, not parameterized DML. How are you defining the target columns in the stage? The bind variables would have to match up to the columns defined in the DML and the stage. RCP and schema files seems to me to be the proper choice here from what you've posted so far. Unless I'm completely missing something.