How to call Oracle Package/Procedure in oData

[Former Member]

Dear Experts, Good Day!

Query on Sending Data to BackEnd System through oData Service.

Is it possible to call the Oracle package/procedure through oData(Data Source as JDBC)?

Ex.. To approve the workflow record from the mobile device needs to call the oracle package as below.

BEGIN

                     praxis_pkg_oracle_approvals.approve (i_pid => 'value',

                     i_status            => 'Attribute Value',

                     i_comments   => 'Attribute Value',

                     i_user_id         => ''Attribute Value',

                     i_to_user_id => 'Attribute Value',

                     i_device_id => 'Attribute Value'

                     );

END;

Kindly Suggest.

[agentry_src]

Discussion successfully moved from SAP for Mobile to SMP Developer Center as the more appropriate venue for this question.

Regards, Mike (Moderator)

SAP Technology RIG

[midhun_vp]

Hi Tirupati,

If you are using SAP Mobile Platform 3 you could use Integration Gateway to  convert your JDBC to Odata.

You could follow this document:

Regards,Midhun

SAP Technology RIG

[Former Member]

Dear Midhun,

Thanks for your reply!

Yes, we are using the SMP3(SP07), also converted the JDBC to Odata for reading the data from Oracle Back-End System, its working perfectly fine. As I mentioned in the post, Is it possible to call the oracle package/procedure through oData(Data Source as JDBC).

Environment Details:

Server : SMP3.0 SP07

SDK : SP07

Using the integration gateway.

Regards,

Tirupati

[PavelPenaz]

Hi Tirupati,

As far as I know, stored procedures in general are not supported with Integration Gateway and JDBC - though looping in to help us confirm.

Thanks,

Pavel

[bjoernw]

Hi Tirupati,

unfortunately Pavel is right and JDBC Stored Procedures are not yet supported in the Integration Gateway component in SMP3 SP07. We are working on providing support for this for one of the next SPs, but we cannot make any commitments for this yet.

Kind regards

Björn

[Former Member]

Thanks Bjoern for the confirmation!