Subject | Stored procedure array input parameters |
---|---|
Author | Daniel Miller |
Post date | 2004-11-08T08:09:09Z |
Are there any plans to implement array input parameters for stored
procedures?
I'm trying to use stored procedures to hide the database implementation
from my application - so I can change my table structure with virtually
no changes to my app. So far, it's gone reasonably well.
My problem now is trying to work with a group of records as a single
entity. I didn't want to use array columns as this requires a fixed
dimension - and I wanted it variable. But now I don't see how to send a
variable amount of information to a procedure for storage. The only way
I see it now is to declare a fixed list of input parameters - more than
I anticipate storing, and then checking those parameters for null
values. This seems clumsy.
If someone has a better idea, please share!
Daniel
procedures?
I'm trying to use stored procedures to hide the database implementation
from my application - so I can change my table structure with virtually
no changes to my app. So far, it's gone reasonably well.
My problem now is trying to work with a group of records as a single
entity. I didn't want to use array columns as this requires a fixed
dimension - and I wanted it variable. But now I don't see how to send a
variable amount of information to a procedure for storage. The only way
I see it now is to declare a fixed list of input parameters - more than
I anticipate storing, and then checking those parameters for null
values. This seems clumsy.
If someone has a better idea, please share!
Daniel