Subject Re: [firebird-support] Overflow occurred during data type conversion
Author Net Firebird
Post date 2013-10-08T14:47:08Z
my procedure code is as follows. 

CREATE PROCEDURE SP_GET_MINIWEB_EVENTS (
    MINIWEB_NAME NAME,
    LANGUAGE_CODE LANGUAGE_CODE )
RETURNS (
    EVENT_ID ID,
    EVENT_DATE Date,
    EVENT_TIME Time,
    TITLE EVENT_TITLE,
    DESCRIPTION DESCRIPTION,
    PRICE MONEY,
    VENUE VENUE,
    ADDRESS ADDRESS,
    WEBSITEURL WEBSITEURL,
    EVENT_TYPE_NAME NAME,
    PROVINCE_NAME PROVINCE_NAME )
AS
BEGIN

    FOR
    SELECT e.event_id
      ,e.event_date
      ,e.event_time
      ,e.title
      ,e.description 
      ,e.price
      ,e.venue
      ,e.address
      ,e.websiteurl
      ,et.event_type_name
      ,p.province_name
  FROM t_event e join event_type_translation et on (e.event_type_id=et.event_type_id) join language l on (l.language_code=et.language_code) 
  join miniweb m on (m.party_id=e.party_id)
  join province p on (e.province_id=p.province_id)
      where m.miniweb_name=:MINIWEB_NAME and l.language_code=:language_code and e.event_date>='today'
      order by e.event_date, e.event_time
        INTO
        :event_id, :event_date, :event_time, :title, :description, :price, :venue, :address, :websiteurl, :event_type_name, :province_name
     do
        SUSPEND;
END




On Mon, Oct 7, 2013 at 7:56 PM, Leyne, Sean <Sean@...> wrote:
 

You need to provide some better context (SP source code), the error message alone does not provide any details from which an explanation could be derived.

 

 

Sean

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Net Firebird
Sent: Sunday, October 06, 2013 5:02 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Overflow occurred during data type conversion

 




When using in selectable stored procedure data type Varchar(8191) I keep getting

 

Overflow occurred during data type conversion 

 

this is my domain 

CREATE DOMAIN DESCRIPTION

 AS Varchar(8191)

 COLLATE UNICODE_CI_AI; 

 

There is no conversion needed as the same domain is used in table field and stored procedure returns parameter. 

however when just doing select it works fine. but inside SP not. What might be the problem? 

FB 2.5.2