?
Solved

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

Posted on 2004-11-29
12
Medium Priority
?
359 Views
Last Modified: 2008-01-09
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?
0
Comment
Question by:rambosh
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 7

Expert Comment

by:jacobhoover
ID: 12699752
Can you post the procedure in question, as this is an Oracle error.

Jake
0
 
LVL 14

Accepted Solution

by:
Tommy Kinard earned 0 total points
ID: 12699774
Just as a guess you have a variable defined as an integer and it should be defined as a long.

dragontooth

0
 

Author Comment

by:rambosh
ID: 12699786
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Expert Comment

by:mugman21
ID: 12703114
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
 
LVL 8

Expert Comment

by:mugman21
ID: 13081516
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
 
LVL 20

Expert Comment

by:Venabili
ID: 13082048
Coffee, rereading and oops

I agree actually...

 
0
 
LVL 8

Expert Comment

by:mugman21
ID: 13082141
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
 
LVL 20

Expert Comment

by:Venabili
ID: 13082281
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
 
LVL 8

Expert Comment

by:mugman21
ID: 13082342
Justice has been done, and for you dragontooth, your welcome whoever you are....

Mugman
0
 
LVL 14

Expert Comment

by:Tommy Kinard
ID: 13082744
mugman21,

Thanks, I owe you one. :)

dragontooth


0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question