can we read an Oracle DB View from SAP PI

[Former Member]

Hi Frnds,

Can we read oracle view from sap pi?

pls advice

Regards,

Narendra

[iaki_vila]

Hi Narendra,

A few cents. First of all, you would need to check if the jdbc Oracle driver is deployed. Check the the Oracle jdbc version that you need in Sumit Goel's document http://scn.sap.com/docs/DOC-45748. When you had your driver correctly installed you can follor  Indrajit Sarkar suggestion because the xml document is the same for all jdbc drivers, check also this Bhavesh Kantilal how-to  for the receiver side http://scn.sap.com/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select...

A little tip, depending of your PI version driver installation can change a bit, for PI 7.1X check this document http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

Regards.

[Former Member]

Hi Narendra

The easiest way would be write a stored procdeure in the data base and then call that store procedure

from the receiver JDBC adapter.

Following is the xml format for calling a stored procedure

<StatementName>  

<storedProcedureName action=” EXECUTE”>

    <table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName > 

  </StatementName>

[gagandeep_batra]

Yes You can use this in sender jdbc channel as same as table name

& check this also:

http://scn.sap.com/thread/3200757

Regards

gagan

[Former Member]

Hi gagan,

Sorry to mention , in my case it is receiver.....How to handle view at receiver side.

Can we directly write a quires in place of table and we can put as view and call the view table?

Suggest me if i am wrong....

Regards,

Narendra