Informix Store Procedure

[Former Member]

Hi,

I executed a Store Procedure in Informix DB to started a process. This Procedure has the following return parameters:

CHAR,

SMALLINT,

CHAR,

CHAR;

My problem is in Inbound Message Payload that received the following error message, because it can´t use "(" as tag definition:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

-

-

---

A name was started with an invalid character. Error processing resource 'http://xidev:50000/mdt/messagecontentservlet?attac...

<(expression)>01</(expression)>

---^

Does anyone knows another way to solve this problem?

Regards

Damian

[Former Member]

Hi Damian,

Did you get fix this issue? I'm facing the same problem.

Regards,

Luis Diego

[former_member272911]

Hi,

Is it possible to change the store procedure. In stored procedure pobably the character "(" can be replaced by something.

ELSE Try to use pattern for that field in the data type.

Thanks

kamath

[Former Member]

People, i have the same problem, but solutuion is:

change in the declaration of procedure to return the result set

ex:

CREATE FUNCTION Nome_Arquivo ()

RETURNING CHAR(100) AS arquivo DEFINE vArq LIKE fs_full.nome_arquivo;;

select first 1 nome_arquivo INTO vArq

from fs_full;;

RETURN vArq;;

END FUNCTION

;

Routine created.

In RETURNING use "AS" enter field names your date types.

its work.

abs

[VijayKonam]

Hi,

How does you stored procedure returning the data? Is that a Recordset? Or any dynamic name is used for the fields? Looks like the returning not happening as expected..!!

VJ