Net Firebird wrote:

> 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
>
>
>
>

Hej,
what about some sample data? We don't have crystal balls....
Are you sure the problem is caused by the domain DESCRITPION?
Aside that - ever thought about naming conventions?
Naming a domain and use the same name as returning variable?

Marcus

> On Mon, Oct 7, 2013 at 7:56 PM, Leyne, Sean <Sean@...
> <mailto: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>
> [mailto: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
> <mailto: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____
>
>
>
>
> ____
>
> ____
>
>
>