Passing parameter from Hashed to ODBC stage
Posted: Mon Dec 02, 2013 2:50 pm
Hi all,
I have a problem with passing arguments from a hashed file stage to an ODBC stage. What I am trying to pass is a list of table names, and for each table name that should be passed from the hashed file stage to the ODBC stage, the following SQL select stagement should execute and retrun the result:
but it results in
I also tried substituting '#SOURCE_TABLE_NAME' with a '?', but that didn't make any difference either. Any ideas what is causing this error? The SOURCE_TABLE_NAME column is in the Hashed file is defined as VarChar with a length of 30.
Thanks for your input,
Seyed
I have a problem with passing arguments from a hashed file stage to an ODBC stage. What I am trying to pass is a list of table names, and for each table name that should be passed from the hashed file stage to the ODBC stage, the following SQL select stagement should execute and retrun the result:
Code: Select all
select length(replace(replace(replace(dbms_metadata.get_ddl('TABLE','#SOURCE_TABLE_NAME#'),' ',''),chr(13), ''),chr(10),'')) FROM dual;
Code: Select all
call to SQLExecute failed.
SQL statement:select length(replace(replace(replace(dbms_metadata.get_ddl('TABLE','#SOURCE_TABLE_NAME#'),' ',''),chr(13), ''),chr(10),'')) FROM dual
SQLSTATE=S1000, DBMS.CODE=31603
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-31603: object "#SOURCE_TABLE_NAME#" of type TABLE not found in schema "DFFSSD"
Thanks for your input,
Seyed