Four Stars

How to create Oracle CLOB to S3

Hi Gurus

 

I have requirement to create Oracle CLOB into json file into S3.

I have followed steps as below.

1. Created Oracle input component ( Query has ClOB and File_name) 

Picture1.JPG

2. Created JavaFlex Component  (Code Attached in the Screenshot)

picture_2.JPG

3. CreateFileout(for testing i use local folder) - but i need to send the file to S3 for file_name( file name is from the Query ).

 

4. if the Oracle 10 rows - need to push 10 files to S3.

Note : S3 connection got established . 

 

Could you please any one help me on this ?

 

I am getting error when run the Job.

 

error_page.JPGflex_edit_schema.JPG

 

 

Thanks

Mani

1 REPLY
Moderator

Re: How to create Oracle CLOB to S3

Hello mani,

When you get some compile errors, please check your "Code" tab in your job. There will be your compile error highlighted in red line.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.