| | | | | Browse by category |
Article ID: 989
Last updated: 02 Feb, 2008
Problem
The DBTools.h++ documentation describes how an RWDBBlob can be streamed into an RWDBStoredProc object. But when I tried to define a Sybase stored procedure with a text/image as an input parameter, the compilation failed with an error message that these are not valid input parameter types.
Cause
With Sybase, text and image datatypes have certain restrictions. These datatypes cannot be used as parameters to a stored procedure. This is a limitation of Sybase and may not be true amongst all databases. Here is an excerpt from the Sybase 11 manual.
Action
The DBTools.h++ documentation describes how an RWDBBlob can be streamed into an RWDBStoredProc object. But when I tried to define a Sybase stored procedure with a text/image as an input parameter, the compilation failed with an error message that these are not valid input parameter types.
Cause
With Sybase, text and image datatypes have certain restrictions. These datatypes cannot be used as parameters to a stored procedure. This is a limitation of Sybase and may not be true amongst all databases. Here is an excerpt from the Sybase 11 manual.
Sybase SQL Server Reference Manual, Chapter 2: System and User Defined Datatypes
Restrictions on text and image Columns
Text and image columns cannot be used:
- As parameters to stored procedures or as values passed to these parameters
- As local variables
- In order by, compute, and group by clauses
- In an index
- In subqueries or joins
- In a where clause, except with the keyword like
- With the + concatenation operator
Action
This article was:
Helpful |
Not helpful
Report an issue
Article ID: 989
Last updated: 02 Feb, 2008
Revision: 1
Views: 3091
Posted: 06 Nov, 1998 by
Dean J.
Updated: 02 Feb, 2008 by
Dean J.
Others in this category
Why won't the InfoBrowser contents update in response to selection changes in ClassView or FileView?
Powered by KBPublisher (Knowledge base software)