 |
 |
Archives of the TeradataForum
Message Posted: Tue, 01 Jul 2003 @ 15:51:55 GMT
| Subj: | | Re: Type "Cursor" is not available |
| |
| From: | | Geoffrey Rommel |
| | I am working on Teradata version VR4.1 "Declare Cursor" doesn't work on it. The "For Cursor" statement works fine but for "Declare
Cursor" it gives me an error saying type "cursor" is not available. | |
It sounds as if you are trying to use "declare cursor" within a stored procedure. This is impossible. "Declare cursor" works only in
embedded SQL. See SQL Reference, Vol. 6, p. 3-45.
| | Now my problem is that if i use "for cursor" statement instead of Declare Cursor, the query become more expensive. | |
Yes, stored procedures are expensive. You should try to use straight SQL if possible -- it usually is.
| |
