Calling a stored procedure from an IWS REST API - parameter problem

I want to call a SQL stored procedure using an IWS REST API. I have it working as long as I hardcode all stored procedure parameters in the SQL call statement. I can't get it to work when I try to pass in parameters in the REST API request.

My stored procedure is named MYSPROC. It contains 5 parameters.
(IN ACTION_PARM CHAR (20),
IN PARM_STUDENT_ID INT DEFAULT NULL,
IN PARM_FIRST_NAME CHAR (30) DEFAULT NULL,
IN PARM_LAST_NAME CHAR (30) DEFAULT NULL,
IN PARM_EXAM_NAME CHAR (15) DEFAULT NULL,
IN PARM_EXAM_SCORE INT DEFAULT NULL)

I have created a REST API in an IWS web services server. Here are the details:

* Base resource URL:
http://mysystem:myport/web/services/examscores

* Procedure name:
getonescore

* Procedure SQL statement:
CALL MYSPROC ('GETONESCORE',12345,' ',' ','20 FALL FINAL',0)

* HTTP request method:
GET

* The URI path template for method is:
/getonescore

This works. The URI "http://mysystem:myport/web/services/examscores/getonescore"; returns the score for student 12345 on the 20 FALL FINAL exam.

Now, I would like to switch out the hardcoded values for input parameters. I would like to get the same result as above, but pass in a student ID number and an exam name. I had imagined a URI something like this:
http://mysystem:myport/web/services/examscores/getonescore?PARM_STUDENT_ID=12345&PARM_EXAM_NAME="20 FALL FINAL"

I redeployed the same procedure with a few modifications. Here are the details:

* Procedure name:
getonescore

* Procedure SQL statement:
CALL MYSPROC ('GETONESCORE',?,' ',' ',?,0)
PARM_STUDENT_ID input INTEGER
PARM_EXAM_NAME input CHAR

* HTTP request method:
GET

* The URI path template for method is...
This is where I think that I'm falling down. No matter what I try, I cannot seem to create a URI path template that will accept the parameters.

According to RCF 6570, this URI template:
/foo{?query,number}
is supposed to expand to this URI:
/foo?query=mycelium&number=100

So I tried this as a URI path template for the method:
/getonescore{?PARM_STUDENT_ID,PARM_EXAM_SCORE}
using *PATH_PARAM. But it didn't work.

I tried all kinds of variations:
/getonescore{?PARM_STUDENT_ID&PARM_EXAM_SCORE}
/gentonescore?{PARM_STUDENT_ID}{PARM_EXAM_SCORE}
/gentonescore?{PARM_STUDENT_ID}&{PARM_EXAM_SCORE}
/getonescore/{?PARM_STUDENT_ID,PARM_EXAM_SCORE}
Most of the time I get 404 Resource Not Found messages.

Any help with getting a correct URI path template for the method would be appreciated.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486 ext. 12676
www.dotfoods.com<http://www.dotfoods.com>