Stored Procedure Call with multiselect prompt

[mgraf]

Hi All
I am familiar with the use of a stored procedure in Impromptu. But I would like to pass in multiple values to the Stored Procedure's parameter (e.g. a portfolio list). So far I was only able to use a single portfolio. Can I give the user a prompt with multiselection in the use with the stored procedure?

The procedure I call looks like:

PROCEDURE PRC_POP_ASSET_TOTAL_ASCAT_DTS (
I_PORTFOLIO_CD IN VARCHAR2,
I_REPORT_DATE_YYYYMMDD IN VARCHAR2,
C2 IN OUT cursor_type) AS ...

In Cognos Impromptu it looks like:

call PK_POP_ASSET_TOTAL_ASCAT_DTS.PRC_POP_ASSET_TOTAL_ASCAT_DTS(?I_PORTFOLIO_CD? IN, ?I_REPORT_DATE_YYYYMMDD? IN)

I really hope that someone had similar problems.
Mike

 

[rammmi]

My answer is very late, but it's very helpfull for all persons who want to make report with calling stored procedure.
The way to pass parameter to stored procedure is :
Report + Stored procedure
1- Only Char variable must used.
2- each parameter must have the same name's parameter of the stored procedure.
3- we must specify the type of parameter (IN or Out)
Note : the type out make a reference to a ouptut parameter in the stored procedure.

Macro + Report
4- if we have to pass parameter in macro we must use one char variable that contain all parameters separated by this caracter | .