| |
| 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
|
|
| Hits/month |
2,500,000+ |
Downloads (Since May 2000) |
7,393,709 |
| Total Files |
6,023 |
| Forum msgs |
7,670 |
| Articles/FAQs |
70+/900+ |
Top Selling Software at Amazon
|