| Oracle 8 and returning the REF CURSOR from a stored procedure |
|
|
Using Delphi 4 (w/BDE 5) with the Oracle 8.0.4 client and the Oracle 8 SQL Link driver, I am trying to execute a stored procedure that returns a REF CURSOR type. No matter what I seem to try I get the error "General SQL error ORA-0 036: illegal variable name/number" when I try to execute the procedure. What am I doing wrong? When using BDE 5.0 there is a known problem with returning a REF CURSOR type from a stored procedure when using the Oracle 8 SQL Link Driver (in BDE 5.0). BDE 5.0 or later resolves the problem.
|
| 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 |
Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use