Parameters for Stored Procedure in Framework Manager

[vamsivanka]

We have a stored procedure that is working fine with Static values.

when i change the Values from Static to #Prompt('P_FY')#
and validate, i am getting the following error


RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0144 Prompt 'P_FY' has no substitution values.

Please see the attachment for Error.
Right now we are using 10.2.1 FP6.
can any one help with this ?

[MFGF]

We have a stored procedure that is working fine with Static values.

when i change the Values from Static to #Prompt('P_FY')#
and validate, i am getting the following error


RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0144 Prompt 'P_FY' has no substitution values.

Please see the attachment for Error.
Right now we are using 10.2.1 FP6.
can any one help with this ?

Hi,

You simply need to provide a default value for the parameter to allow FM to validate the query subject. You could either do this in the syntax of the prompt macro #prompt('P_FY','token','2014')#, or alternatively edit the definition of the query subject, go to the Test tab, use the Options link in the bottom right corner and then press the Prompts button and enter your default there.

Cheers!

MF.