General SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesGeneral SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old April 1st, 2004, 05:31 AM
adityachs adityachs is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Posts: 1 adityachs User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Exclamation Problem with oracle ref cursor in VB6

This is Aditya ,we are working on a Project, in which r getting a peculiar problem .

The project is in Visual Basic with oracle Database and the ODBC was Intersolv ODBC driver for Oracle. The Project was developed 2-3 years back. Now we need to add new features to the existing system.The project is working fine with the Production Database. Now we created a Database for development as just replica of Production database.
We are encountering the following error while working with the new Development environment and application closes abnormally.
" 0x286a87cf" referenced memory at "0x00000047" the memory could not be read

While debugged we found that the problem is encountering only when some stored procedures which are using "REF" cursors are called from VB code.We recompiled all procedures in Development Environment.

The project is working fine for production (original) database but not working for development database (replication) and also working when calling to procedures, which are not using ref cursors in Development Environment. When we replaced the code of procedures (which are using ref cursors) with SQL statements in VB with record set (i.e., RS.Open "select ...from ...where...",con) its working even in Development Environment.

Could you plz let us know what might me the exact problem.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesGeneral SQL Development > Problem with oracle ref cursor in VB6


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway