Max parameters in Stored Procedure signature ?

[BJE_DBA]

I tried to find this on tahiti and searched here, but I am not getting what I need.

Customer wants a procedure with 125 'inputs' which I take to mean parameters. Sounds like a great opportunity for native sql tables in 9i where it looks like a table but is sql loaded and read-only.

BUT they are on oracle 8i. So I may have to grind this out with a bazillion parameters.

How many can I have ?

thanks

[slimdave]

I don't know of a limit -- you might like to just try and find it yourself through experimentation.

[BJE_DBA]

Originally posted by slimdave
I don't know of a limit -- you might like to just try and find it yourself through experimentation.

I may have to. I wanted to know going into tomorrow mornings call if this strategy was even possible. They want all this stuff done by thanskgiving and going down the wrong path wont help. Need to spend tonight reading the ERD's and DOCs and VISIO diagrams to get a feel as to wether or not I have time to hammer this out.