Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
how many at max we can define??
Printable View
Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
how many at max we can define??
There can be any number of paramters for a procedure in oracle but in SQL Server 2000 the number is 2100 .
Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.
[QUOTE=Sant_parkash;19789]Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
how many at max we can define??[/QUOTE]
No, there is no limit for declaring the parameter in procedures.
no, that restriction is only upto Ora8i
[QUOTE=Sant_parkash;19793]Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.[/QUOTE]
As i have told you, there is no limit on the number of parameters for a procedure in oracle.