How to call Packaged Stored Procedure in JDBC Adapter?

[Former Member]

hello frnds,

I m working on a SAP R/3 -> XI -> Oracle scenario. Here on receiver side i m using JDBC Adapter in which i m using a stored procedure.

I have my stored procedure in a Package. Example : package "PKG_SPARES_VOR_UPLOAD" and in that stored procedure "pr_spares_vor_po_hdr_upload".

i have checked that if i write this stored procedure outside the package then it works fine... but if i put it into the package then it is giving me error that ....

" Receiver Adapter v2112 for Party '', Service 'BS_ORADEV':

Configured at 2006-08-16 10:12:14 GMT+05:30

History:

- 2006-08-16 11:02:04 GMT+05:30: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PR_SPARES_VOR_PO_HDR_UPLOAD' (structure 'statement'): java.sql.SQLException: ORA-06550: line 1, column 7:

PLS-00201: identifier 'PR_SPARES_VOR_PO_HDR_UPLOAD' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored ".

please help me out with this problem.

Thankx,

Regards,

Audumbar

[Former Member · Accepted solution]

Hi Audumbar,

as far as I know you have to call the SP seperated with a DOT:

PKG_SPARES_VOR_UPLOAD.PR_SPARES_VOR_PO_HDR_UPLOAD

Regards Mario

[Former Member]

Hi,

I have the same problem to call a stored Procedure in a Package.

If my procedure is not in a package, everything is right.

And I musn't indicate all the name, because I musn't put '.' in the name (of the procedure), in my DT on XI.

It would be so nice to have an answer.

Rémi

[bhavesh_kantilal]

Hi,

can u post the format of the data type that is causing you the error.

Regards,

Bhavesh