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.

how to solve "space must be allocated for bind parameter" when calling a stored proc with returned parameters in powerbuilder?

2 posts in Appeon (partner product) Last posting was on 2004-05-12 00:54:19.0Z
samuelzhu Posted on 2004-05-11 16:07:57.0Z
Sender: 255c.40a0f9fb.1804289383@sybase.com
From: samuelzhu
Newsgroups: sybase.public.appeon
Subject: how to solve "space must be allocated for bind parameter" when calling a stored proc with returned parameters in powerbuilder?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40a0fa5d.2571.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 May 2004 09:07:57 -0700
X-Trace: forums-1-dub 1084291677 10.22.241.41 (11 May 2004 09:07:57 -0700)
X-Original-Trace: 11 May 2004 09:07:57 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:238
Article PK: 12448

I create a stored procedure to retrieve some information
from database,i.e.(simplified)

CREATE PROCEDURE getinfo
@info varchar(20) output
AS
select @info='sdfsdfsdf'
GO

then in powerbuilder, I want to use the stored procedure to
get the result, like this:

string infos
declare mysp procedure for getinfo @info=:info OUTPUT;
execute mysp;
if sqlca.sqlcode<>0 then
messagebox("error",sqlca.sqlerrtext)
end if

but the error "space must be allocated for bind parameter"
occurs.
thanks for you advice in adcance.


Julie Jiang Posted on 2004-05-12 00:54:19.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <40a0fa5d.2571.1681692777@sybase.com>
Subject: Re: how to solve "space must be allocated for bind parameter" when calling a stored proc with returned parameters in powerbuilder?
Lines: 35
Organization: Appeon Corporation
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 61.144.207.53
X-Original-NNTP-Posting-Host: 61.144.207.53
Message-ID: <40a175bb@forums-1-dub>
Date: 11 May 2004 17:54:19 -0700
X-Trace: forums-1-dub 1084323259 61.144.207.53 (11 May 2004 17:54:19 -0700)
X-Original-Trace: 11 May 2004 17:54:19 -0700, 61.144.207.53
X-Authenticated-User: appeon
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:239
Article PK: 20647

Hi Samuel,

It sounds like your question is about PowerBuilder and not Appeon. If so,
please re-post on the PowerBuilder board. Your post is likely to get much
better response on the appropriate board.

Thanks,
Julie Jiang
Appeon Corporation

<samuelzhu> wrote in message news:40a0fa5d.2571.1681692777@sybase.com...
> I create a stored procedure to retrieve some information
> from database,i.e.(simplified)
>
> CREATE PROCEDURE getinfo
> @info varchar(20) output
> AS
> select @info='sdfsdfsdf'
> GO
>
> then in powerbuilder, I want to use the stored procedure to
> get the result, like this:
>
> string infos
> declare mysp procedure for getinfo @info=:info OUTPUT;
> execute mysp;
> if sqlca.sqlcode<>0 then
> messagebox("error",sqlca.sqlerrtext)
> end if
>
> but the error "space must be allocated for bind parameter"
> occurs.
> thanks for you advice in adcance.