passing mutiple values in stored procedure

[dm21]

Hi,

I would like to know how can I pass multiple values in stored procedure call.


Impromptu versesion = 7.0
and databae is sybase 12

Thanks

 

[Prasad678]

Hi,

call PACKAGEMANE.PROCEDURENAME(?Prompt1? IN, ?Prompt2? IN)

If the i/p parameter is varchar2 - the prompt should be of string type & respectively for all other datatypes.

Prasad.

 

[dm21]

Hi Prasad,

Thanks for replying me.

But I wanted to know how can pass multiple value per prompt
i.e. say I would like to pass ('TORONTO', 'MONTREAL') at the same time to prompt ?city?

I know you can do if you type in. I wanted to know if there is anyway through pick list. Becuase when pass values to stored procedure parameters the pick list just gives ability to choose one value.

 

[semby]

You should be able to select multiple values using a regular catalogue picklist

The way to do this is, in your Prompt Manager you must choose
"data" in ("prompt picklist&quot

rather than "data" = "prompt picklist"

where "data" is the field in question
and "prompt picklist" is the picklist defined in prompt manager.

The prompt will then allow you to select multiple values.

Cheers!

-Charles

 

[dm21]

Charles,

Yes you can do in the list query. I don't think it possible in in Stored procedure call template