DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
hishamzz
Participant



Joined: 12 Feb 2008
Posts: 12

Points: 158

Post Posted: Thu Dec 21, 2017 12:19 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: PL/SQL, Oracle Connector, Execute Immediate, Sparse Lookup
Hi Folks,

I am trying to execute a SQL via a PL/SQL block using the Oracle Connector stage. Example as follows :-

Code:
declare 
  sql_stmt     varchar2(4000); 

begin 
   
  sql_stmt := 'SELECT SECTOR_ID FROM SECTOR_DIM'; 
  execute immediate sql_stmt;
end;



I have defined the SECTOR_ID column in the Oracle Connector stage but the output is coming as NULL. As in, nothing is being mapped.

To give context into why I am trying the above. The idea is perform a sparse lookup and replacing the SELECT statement above with a select statement coming from an input column.

Would appreciate if anyone would help tinker the above PL/SQL so that i would be able to get the required output.

Regards,
Hisham
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours