Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Delphi4, Oracle 7.x stored procedures with multiple parameters with one being a REF Cursor


I have a stored procedure on my Oracle 7.x server that has multiple parameters with one of them being a REF Cursor type. When I try to execute this procedure I get "invalid cursor" errors. I used to be able to execute this procedure in Delphi 3, why doesn't it work in Delphi 4?   

    Parameter binding behavior was changed in Delphi 4. In Delphi 4 if you don't give a parameter a value it assumes that the value you wanted was NULL. This causes a problem for the REF Cursor type in Oracle because the server doesn't accept NULL as an input value for a REF Cursor type. The workaround for this issue is to set the value of the REF Cursor parameter to 0 (zero) at either design time or at runtime before the procedure is executed. This change in behavior will be accounted for in a later version of the BDE (> 5.0).

    3/26/99

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use