Using RWDBBlob with a stored procedure on Sybase

Article ID: 989
Last updated: 02 Feb, 2008
Article ID: 989
Last updated: 02 Feb, 2008
Revision: 1
Views: 3042
Posted: 06 Nov, 1998
by Dean J.
Updated: 02 Feb, 2008
by Dean J.
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.

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: 3042
Posted: 06 Nov, 1998 by Dean J.
Updated: 02 Feb, 2008 by Dean J.

Others in this category