What is the max for parameters

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
CreoWill
Posts: 1
Joined: Wed 14 Oct 2009 19:40

What is the max for parameters

Post by CreoWill » Wed 14 Oct 2009 19:47

Using the package wizard to create wrapper class, getting error.

Failed to describe stored procedure.
Do you want to skip it and continue?

I get this error if I have more than 99 parameters. Is 99 parameters the max?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 15 Oct 2009 14:49

I have tried generating the typed Oracle package via Tools | Oracle | Oracle Package Wizard for the package, the script of which is posted below. It works fine. Please try generating class for this test_1015_pack_200 package. If the problem persists only with your own package, please send us ( http://www.devart.com/company/contact.html ) your script. Also please specify your current version. You can see it in the Tools | Oracle | About menu of Visual Studio.

Code: Select all

CREATE OR REPLACE PACKAGE test_1015_pack_200 AS
procedure test1015_200(
a1 in int,
a2 in int,
a3 in int,
a4 in int,
a5 in int,
a6 in int,
a7 in int,
a8 in int,
a9 in int,
a10 in int,
a11 in int,
a12 in int,
a13 in int,
a14 in int,
a15 in int,
a16 in int,
a17 in int,
a18 in int,
a19 in int,
a20 in int,
a21 in int,
a22 in int,
a23 in int,
a24 in int,
a25 in int,
a26 in int,
a27 in int,
a28 in int,
a29 in int,
a30 in int,
a31 in int,
a32 in int,
a33 in int,
a34 in int,
a35 in int,
a36 in int,
a37 in int,
a38 in int,
a39 in int,
a40 in int,
a41 in int,
a42 in int,
a43 in int,
a44 in int,
a45 in int,
a46 in int,
a47 in int,
a48 in int,
a49 in int,
a50 in int,
a51 in int,
a52 in int,
a53 in int,
a54 in int,
a55 in int,
a56 in int,
a57 in int,
a58 in int,
a59 in int,
a60 in int,
a61 in int,
a62 in int,
a63 in int,
a64 in int,
a65 in int,
a66 in int,
a67 in int,
a68 in int,
a69 in int,
a70 in int,
a71 in int,
a72 in int,
a73 in int,
a74 in int,
a75 in int,
a76 in int,
a77 in int,
a78 in int,
a79 in int,
a80 in int,
a81 in int,
a82 in int,
a83 in int,
a84 in int,
a85 in int,
a86 in int,
a87 in int,
a88 in int,
a89 in int,
a90 in int,
a91 in int,
a92 in int,
a93 in int,
a94 in int,
a95 in int,
a96 in int,
a97 in int,
a98 in int,
a99 in int,
a100 in int,
a101 in int,
a102 in int,
a103 in int,
a104 in int,
a105 in int,
a106 in int,
a107 in int,
a108 in int,
a109 in int,
a110 in int,
a111 in int,
a112 in int,
a113 in int,
a114 in int,
a115 in int,
a116 in int,
a117 in int,
a118 in int,
a119 in int,
a120 in int,
a121 in int,
a122 in int,
a123 in int,
a124 in int,
a125 in int,
a126 in int,
a127 in int,
a128 in int,
a129 in int,
a130 in int,
a131 in int,
a132 in int,
a133 in int,
a134 in int,
a135 in int,
a136 in int,
a137 in int,
a138 in int,
a139 in int,
a140 in int,
a141 in int,
a142 in int,
a143 in int,
a144 in int,
a145 in int,
a146 in int,
a147 in int,
a148 in int,
a149 in int,
a150 in int,
a151 in int,
a152 in int,
a153 in int,
a154 in int,
a155 in int,
a156 in int,
a157 in int,
a158 in int,
a159 in int,
a160 in int,
a161 in int,
a162 in int,
a163 in int,
a164 in int,
a165 in int,
a166 in int,
a167 in int,
a168 in int,
a169 in int,
a170 in int,
a171 in int,
a172 in int,
a173 in int,
a174 in int,
a175 in int,
a176 in int,
a177 in int,
a178 in int,
a179 in int,
a180 in int,
a181 in int,
a182 in int,
a183 in int,
a184 in int,
a185 in int,
a186 in int,
a187 in int,
a188 in int,
a189 in int,
a190 in int,
a191 in int,
a192 in int,
a193 in int,
a194 in int,
a195 in int,
a196 in int,
a197 in int,
a198 in int,
a199 in int,
a200 in int
);
end test_1015_pack_200;
/
CREATE OR REPLACE PACKAGE BODY test_1015_pack_200 AS
procedure test1015_200(
a1 in int,
a2 in int,
a3 in int,
a4 in int,
a5 in int,
a6 in int,
a7 in int,
a8 in int,
a9 in int,
a10 in int,
a11 in int,
a12 in int,
a13 in int,
a14 in int,
a15 in int,
a16 in int,
a17 in int,
a18 in int,
a19 in int,
a20 in int,
a21 in int,
a22 in int,
a23 in int,
a24 in int,
a25 in int,
a26 in int,
a27 in int,
a28 in int,
a29 in int,
a30 in int,
a31 in int,
a32 in int,
a33 in int,
a34 in int,
a35 in int,
a36 in int,
a37 in int,
a38 in int,
a39 in int,
a40 in int,
a41 in int,
a42 in int,
a43 in int,
a44 in int,
a45 in int,
a46 in int,
a47 in int,
a48 in int,
a49 in int,
a50 in int,
a51 in int,
a52 in int,
a53 in int,
a54 in int,
a55 in int,
a56 in int,
a57 in int,
a58 in int,
a59 in int,
a60 in int,
a61 in int,
a62 in int,
a63 in int,
a64 in int,
a65 in int,
a66 in int,
a67 in int,
a68 in int,
a69 in int,
a70 in int,
a71 in int,
a72 in int,
a73 in int,
a74 in int,
a75 in int,
a76 in int,
a77 in int,
a78 in int,
a79 in int,
a80 in int,
a81 in int,
a82 in int,
a83 in int,
a84 in int,
a85 in int,
a86 in int,
a87 in int,
a88 in int,
a89 in int,
a90 in int,
a91 in int,
a92 in int,
a93 in int,
a94 in int,
a95 in int,
a96 in int,
a97 in int,
a98 in int,
a99 in int,
a100 in int,
a101 in int,
a102 in int,
a103 in int,
a104 in int,
a105 in int,
a106 in int,
a107 in int,
a108 in int,
a109 in int,
a110 in int,
a111 in int,
a112 in int,
a113 in int,
a114 in int,
a115 in int,
a116 in int,
a117 in int,
a118 in int,
a119 in int,
a120 in int,
a121 in int,
a122 in int,
a123 in int,
a124 in int,
a125 in int,
a126 in int,
a127 in int,
a128 in int,
a129 in int,
a130 in int,
a131 in int,
a132 in int,
a133 in int,
a134 in int,
a135 in int,
a136 in int,
a137 in int,
a138 in int,
a139 in int,
a140 in int,
a141 in int,
a142 in int,
a143 in int,
a144 in int,
a145 in int,
a146 in int,
a147 in int,
a148 in int,
a149 in int,
a150 in int,
a151 in int,
a152 in int,
a153 in int,
a154 in int,
a155 in int,
a156 in int,
a157 in int,
a158 in int,
a159 in int,
a160 in int,
a161 in int,
a162 in int,
a163 in int,
a164 in int,
a165 in int,
a166 in int,
a167 in int,
a168 in int,
a169 in int,
a170 in int,
a171 in int,
a172 in int,
a173 in int,
a174 in int,
a175 in int,
a176 in int,
a177 in int,
a178 in int,
a179 in int,
a180 in int,
a181 in int,
a182 in int,
a183 in int,
a184 in int,
a185 in int,
a186 in int,
a187 in int,
a188 in int,
a189 in int,
a190 in int,
a191 in int,
a192 in int,
a193 in int,
a194 in int,
a195 in int,
a196 in int,
a197 in int,
a198 in int,
a199 in int,
a200 in int
)as
begin
NULL;
end;
end test_1015_pack_200;
/

Post Reply