JDBC to File Scenario

[Former Member]

I have a scenario where i need to fetch records from Oracle table using a stored procedure and then write it into a file.

I searched the scn but could not find any valid answers.

My aim can also be achieved if there can be a possibility of a File to JDBC synchronous scenario using a stored procedure.

[iaki_vila · Accepted solution]

Hi Ankit,

As far as i know you cant use a stored procedure in a sender jdbc with Oracle (Note 941317 - XI / PI JDBC Adapter: Known Problems / Incompatibilities).

For the sender part you can use oracle table functions: http://scn.sap.com/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-ada...

The file receiver side is easier and you can get a lot of examples in the SCN.

Regards.

[baskar_gopalakrishnan2]

I think you are looking for jdbc to file async.. Yes it is possible. Search scn.

[MichalKrawczyk]

Hi,

>>>My aim can also be achieved if there can be a possibility of a File to JDBC synchronous scenario using a stored procedure.

yes this is possible- search for a blog on file - RFC - file using the request response beans

and just change it to JDBC channel,

Regards,

Michal Krawczyk

[Former Member]

I just came to know that a 3rd party application is used to validate data which is inserted into the table.So File to JDBC synchronous scenario will not solve the problem now. Can you please tell me if a JDBC to File Asynchronous can be possible??

[ambrish_mishra]

Hi Ankit,

File to JDBC asynchronous is indeed possible. Just define your inbound interface as Asynchronous.

Use JDBC receiver format to write the data to the database.

Ambrish

[Former Member]

Hi Ambrish,

I wanted to know about JDBC to file Scenario. JDBC is the sender.

Regards,

Ankit Baid

[ambrish_mishra]

Hi Ankit,

For JDBC to file scenario, you can refer to thread http://scn.sap.com/thread/3411212

I have given detailed response in this thread.

Invoking Oracle stored procedures from within a JDBC sender channel is only possible for Oracle DBMS versions >= 10.2.x using table functions

also check

http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/10/04/pixi-sender-jdbc-adapter-for-orac...

Hope it answers your question.

Ambrish