Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ODBC Error - Invalid character value for cast specification

2 posts in Appeon (partner product) Last posting was on 2005-12-08 02:12:36.0Z
roywong Posted on 2005-12-07 02:46:40.0Z
From: "roywong" <roywong@snpcorp.com>
Newsgroups: sybase.public.appeon
Subject: ODBC Error - Invalid character value for cast specification
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 59.37.14.33
Message-ID: <43964b0d@forums-2-dub>
X-Original-Trace: 6 Dec 2005 18:38:05 -0800, 59.37.14.33
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Dec 2005 18:38:06 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Dec 2005 18:46:40 -0800
X-Trace: forums-1-dub 1133923600 10.22.108.75 (6 Dec 2005 18:46:40 -0800)
X-Original-Trace: 6 Dec 2005 18:46:40 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1255
Article PK: 21113

Dear Sir,

I am using APPEON 3.1 and PowerBuilder 10.2.0 Build 8050. When I call a
stored procedure with parameter as follows, the error message of "invalid
character value for cast specification" is prompted.

Calling Stored procedure

string ls_ponum

ls_ponum = "BCPTFAN04030004"

declare pb_proc procedure for completepo @ponum = :ls_ponum ;

if sqlca.sqlcode = -1 then
messagebox('Declare Error','SQLSTATE'+string(sqlca.sqldbcode) + ' ' +
sqlca.sqlerrtext)
end if

execute pb_proc ;

if sqlca.sqlcode = -1 then
messagebox('execute Error','SQLSTATE'+string(sqlca.sqldbcode) + ' ' +
sqlca.sqlerrtext)
end if

close pb_proc ;

Thanks


Sally.Li Posted on 2005-12-08 02:12:36.0Z
From: "Sally.Li" <appeon.support@appeon.net>
Newsgroups: sybase.public.appeon
References: <43964b0d@forums-2-dub>
Subject: Re: ODBC Error - Invalid character value for cast specification
Lines: 112
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0093_01C5FBDE.F96FC390"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 59.37.44.157
X-Original-NNTP-Posting-Host: 59.37.44.157
Message-ID: <43979694@forums-1-dub>
Date: 7 Dec 2005 18:12:36 -0800
X-Trace: forums-1-dub 1134007956 59.37.44.157 (7 Dec 2005 18:12:36 -0800)
X-Original-Trace: 7 Dec 2005 18:12:36 -0800, 59.37.44.157
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1258
Article PK: 12918

Hi roywong,
 
Considering your following post, the error may be caused by the incorrect connection cache settings. Please refer to my comments in that post and try again.
 
Regards
Sally Li
 
 
"roywong" <roywong@snpcorp.com> wrote in message news:43964b0d@forums-2-dub...
> Dear Sir,
>
> I am using APPEON 3.1 and PowerBuilder 10.2.0 Build 8050.  When I call a
> stored procedure with parameter as follows, the error message of "invalid
> character value for cast specification" is prompted.
>
> Calling Stored procedure
>
> string ls_ponum
>
> ls_ponum = "BCPTFAN04030004"
>
> declare pb_proc procedure for completepo @ponum = :ls_ponum ;
>
> if sqlca.sqlcode = -1 then
>  messagebox('Declare Error','SQLSTATE'+string(sqlca.sqldbcode) + ' ' +
> sqlca.sqlerrtext)
> end if
>
> execute pb_proc ;
>
> if sqlca.sqlcode = -1 then
>  messagebox('execute Error','SQLSTATE'+string(sqlca.sqldbcode) + '  ' +
> sqlca.sqlerrtext)
> end if
>
> close pb_proc ;
>
> Thanks
>
>