DSXchange

Thanks for the information Craig. I'm planning to frame the query before the job starts and send it as a parameter.

Is it possible to send table name to oracle stage when using it in conjunction with a lookup?

I'm able pass column names using ORCHESTRATE.column_name but when I do the same for table name it says invalid table.

Is there any work around for this?

P.S: I'm using sparse lookup

Thanks a lot I finally got it to work although i didn't use cast_to_varchar2 conversion and I had the output column defined as varchar

Resolution: Instead of passing the entire query as a parameter I've passed only the necessary columns in one parameter and the filter conditions in another parameter. In the oracle stage i have something like select #parcolumns# from #partablename# where #parconditions# So instead of passing a param...

Hi Arnd, When i try to do the conversion it says invalid hex number. Is it because my Clob data is more than 4000 characters? And isn't the code mentioned for conversion of blob to varchar. I was looking for Clob to Varchar. The reason i need this is because i have select statement that has more tha...

The job aborted with the following error main_program: Internal Error: (colDesc):orautils.C: 1722: getColDesc failed. Traceback: msgAssertion__13APT_FatalPathFPCcRC11APT_UStringPCci() at 0xd583d20c querySchema__12APT_OraUtilsFPCwP12APT_ErrorLogi() at 0xd6d72248 describeOperator__19APT_OraReadOperato...

The return type of a function that we use is CLOB and I need to use that function in an oracle stage. Is is possible to read a clob object in an Oracle stage. If not is there any workaround for this?

Thanks,
Abhinav

@Craig All the columns are concatenated using a single column (each delimited by a comma) and the output of the query is sent to a file. So instead of building separate ETLs for each output file, I can do this in a single ETL and also give the end users the flexibility to select as many number of co...

ya.. how stupid of me..!!
will try doing tht

@Sainath i was not able to understand ur solution.. how will the use of two extra parameters solve my problem.. The queries that i posted are a mere sample of the original ones.. The original queries are more than 500 lines each and there are multiple places where i need to replace the parameters.. ...

Thanks for the suggestion sainath... but the entire query keeps changing depending on the user requirment. So i will not be selecting the same columns everytime. case when for a specific output i ,might use the query case 1 select name,deptid from #parcode# table where table.col1 = #par1# and table....

yabhinav wrote:try this
select to_char(to_date(sysdate),'yyyy-mm-dd') from dual;

it should work

actually u dont need the to_date conversion thr..

select to_char(sysdate,'yyyy-mm-dd') from dual; will also return the same result

try this
select to_char(to_date(sysdate),'yyyy-mm-dd') from dual;

it should work

Well.. tht can be done but im not looking for a work around for this issue..We have a new project coming up which will require us to build a huge number of jobs.. if i can get this to work it greatly reduce our coding effort.

Thanks,
Abhinav

wish it was that simple.

The example i gave was just to for ur understanding.

Lets say i have something like

partranslation ='select abc from #parcode# table where table.col1 = #par1#
and table.col2 = #par2#'

In this case what am i supposed to do??

Thanks,
Abhinav