Max parameters in Stored Procedure signature ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Max parameters in Stored Procedure signature ?

  1. #1
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152

    Max parameters in Stored Procedure signature ?

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I don't know of a limit -- you might like to just try and find it yourself through experimentation.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width