vb application error (run time error '-2147217900 (80040e14): ora-06505:PL/SQL: variable requires more than 32767 bytes of contiguous memory.

Need help. Getting above error when trying to return an oracle cursor from a package to vb. I have 2 input parameters and 3 output parameters. One of which is a ref cursor. I have several other procedures doing the same thing, only this one gets the error. Any idea what it is and how to fix?
ramboshAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jacobhooverCommented:
Can you post the procedure in question, as this is an Oracle error.

Jake
0
Tommy KinardCommented:
Just as a guess you have a variable defined as an integer and it should be defined as a long.

dragontooth

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ramboshAuthor Commented:
Somehow or another, I got it working. I commented out and removed the outbound error parameters and it worked. When I put them back in, it still worked. I must have had some goofy syntax going on. Thanks for your quick response.

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mugman21Commented:
dragontooth is correct, the integer variable needs to be made a long. Although the error seems to not be affecting your application now, the first time you run this code on win 98, it's going to crash and will not handle the error well at all. If your using XP, there is  a good chance that this error will show itself on 2000.
0
mugman21Commented:
Venabili,

I would disagree. This paticular error is caused only be an incorrect variable declaration. Dragontooth was correct in his initial response and I seconded it, he should be rewarded with the points or the question should be deleted with-OUT points being refunded.

People should not be able to view a correct answer provided by an expert, then after resolving their problem claim it was magically fixed somehow without the experts soulution..... I assume when he commented out the problem code, he also commented out the variable declarations, then when uncommenting it, did not remove the comments from the variable declarations forcing the var's to be automatic Varients.

DragonTooth owns this one; or no point refund.

Mugman
0
VenabiliCommented:
Coffee, rereading and oops

I agree actually...

 
0
mugman21Commented:
Understandable..... Coffee is a blessing.....

It's cool you took the time to re-read the responses. EE always has a way of finding a person's time when they should be asleep..... Half asleep now...... and here on EE.......

0
VenabiliCommented:
I try always to find time to reread all if there are objections and to clarify my choice if I disagree with them :)...

For the closing Mod:
The recomemndation is:
Points for: dragontooth

Venabili
0
mugman21Commented:
Justice has been done, and for you dragontooth, your welcome whoever you are....

Mugman
0
Tommy KinardCommented:
mugman21,

Thanks, I owe you one. :)

dragontooth


0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.