Subject | Passing multiple values to a parameter of a stored procedure |
---|---|
Author | SoftTech |
Post date | 2008-11-10T19:15:01Z |
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]
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]