Oracle Stored procedure in FM / error with macro "promptmany"

[Sunchaser]

Dear all,

I'm not really used to work with framework manager in some cases, and I've a problem in calling a procedure.
The procedure have a IN parameter and a OUT parameter (it is supposed to retrieve data and it's working fine in Toad), for the IN parameter I need it to be values from a prompt.
In the Query subject definition, I used the "Macro editor" in order to define something like " # sq(promptmany('Param_in'))# " for the first parameter.
Every thing seems fine and the pacakge is created and published with no error, but in fact in Cognos or in FM (when I do "test" on the procedure) there is the error:" Unknown function 'promptmany' in macro expression ".

Thanks in advance for your help.
vinc.

[Sunchaser]

Hi all,

It is working only when I use: # sq(prompt('Param_in'))#.
I wonder how I'm going to have a multiselect prompt in that case, and pass a quoted string parameter (ex: 'value1, value2, value3, ...') as I was doing before.

Thanks.
vinc.

[JaiCognos]

Hi,

Accessing stored procedure through framework manager:
1.Frame work manager doest not support out parameters.
2.We need to use a concept called cursor variables in the oracle stored procedure.
3.If this cursor variable concept is used i think your procedure has compiled very well if not it would throw an error.
4.Prompt many is macro used to select the multiple values so in your stored procedure how many arguments you have delcared and through in parameter how many values you can pass.