Cannot Use Missing Numeric Input Parameters in SAS Web Services

[ozgegroove]

Hi community,

I am new to SAS Web Services..

I have created a SAS web service using a stored process. This stored process uses numeric and char input parameters. I have not chosen "Requires a non blank value" while creating prompts. But when I try to set null value for numeric parameters, it gives an error. Attached, you can see the request and response files.

Here is an error when I submit the attached request(SUSPICIOUS_FLAG is missing). Also, attached you can see the SUSPICIOUS_FLAG prompt definition screenshots.

"A 'Client' type of exception occurred during execution of 'claim_info_ws1' service.  The exception follows: Exception occurred while parsing value for parameter 'SUSPICIOUS_FLAG'"

Additionally, even it is unrelated, I tried clicking "Missing Values" in Include Special Values in the second tab of the prompt, it still did not work.

It is likely to have some missing values for some numeric parameters. How could I define/submit the request file for such a situation? Urgent help is appreciated a lot. Thanks!!

Regards,

Özge

[boemskats]

Hi ozgegroove,

A bit late, but have a look at the standard way of passing null values via web services, as I assume this is axis2/axiom xml validation complaining.

Look at:

http://www.ibm.com/developerworks/library/ws-tip-null/

http://stackoverflow.com/questions/774192/what-is-the-correct-way-to-represent-null-xml-elements

I'd try two things: either omitting the empty elements from the request entirely, or using the xsi:nil="true" syntax.

What are you using to generate your envelope? Are you generating it yourself or is it output from another application?

Nik