Subject Passing multiple values to a parameter of a stored procedure
Author SoftTech
Greetings All,

I'm using Firebird 1.5

In a stored procedure where clause I can do this:

WHERE DCTBD.TBD_ID IN (1,15,16)

or this when passing an input parameter:

WHERE DCTBD.TBD_ID = :V_TBD_ID

Is there anyway to pass as an input parameter these values 1,15,16 (or others) so that I can have a where clause like this?

WHERE DCTBD.TBD_ID IN(:V_TBD_ID_LIST)

If I'm not clear please let me know.

Thanks,
Mike







[Non-text portions of this message have been removed]