Oracle stored procedure in a package

[Former Member]

Hello,

I'm working on a Web service -> XI -> Oracle scenario.

In the receiver side I'm using JDBC Adapter to call to stored procedure.

I have stored procedure in a package.

For example: package "price_list_pk" and stored procedure "is_pl".

When I try to enter the stored procedure path to XML tags I need to separate between the package and the stored procedure with dot "." and dot is not allowed in XML tag.

I want to now if you have answer for this problem

Have other way to work with stored procedure in packages?

Elad

[prateek · Accepted solution]

dot is not allowed in XML tag.

U try with name "price_list_pk.is_pl". This might work in xml file.

Regards,

Prateek

[Former Member · Accepted solution]

Hello,

I need to enter to DATA TYPE all the path " price_list_pk.is_pl" and "." is not allowed in DATA TYPE.

Elad

[prateek · Accepted solution]

Don't give the name in datatype. Suppose ur structure is as shown

<StatementName2>

<dbTableName action=u201DEXECUTEu201D>

<table>SP_NAME</table>

<access>

Pass SP name as a field value in mapping.

Regards,

Prateek

[Former Member · Accepted solution]

and where I need to add the full path?

Where I need to write the package name?

[prateek · Accepted solution]

In the mapping only u have to provide the package name. So the value of ur table field will be package_name.sp_name.

Regards,

Prateek

[Former Member · Accepted solution]

-

[Former Member]

Hey everyone,

What Elad means is that in the XML structure of JDBC there are 2 places you define the DB\SP name:

1. Defined in the structure itself as an element name. (DT)

2. Mapped with a constant to a subelement called TABLE. (MM)

The MM shouldn't be a problem as a value can get the dot character.

But, in the DT structure, because you define here a XSD (XML structure) there is a problem naming the element with the dot character being part of the name as this character is not accepted in a XML tagname.

The right question is if anyone knows of a special XML attribute with which you could define that the element name would contain a dot character? Or else a creative way to call a Stored Procedure inside a Package despite the disabilities above?

Ben