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.

%1 returned a result set with a different schema than expected

2 posts in General Discussion Last posting was on 2009-11-27 08:48:15.0Z
janis Posted on 2009-11-26 22:09:54.0Z
From: janis <janimie@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: %1 returned a result set with a different schema than expected
Date: Thu, 26 Nov 2009 14:09:54 -0800 (PST)
Organization: http://groups.google.com
Lines: 16
Message-ID: <77bee380-d9bf-4e6b-a7d2-299c0cf59716@m3g2000yqf.googlegroups.com>
NNTP-Posting-Host: 195.241.168.22
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259273394 29417 127.0.0.1 (26 Nov 2009 22:09:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 26 Nov 2009 22:09:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m3g2000yqf.googlegroups.com; posting-host=195.241.168.22; posting-account=T_ezLQoAAAC_FIZX9ZP3WTOqAwZ7JloT
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!news-out.readnews.com!transit3.readnews.com!postnews.google.com!m3g2000yqf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28699
Article PK: 77944

Hi, iam getting the next error: %1 returned a result set with a
different schema than expected
Where can i find the result set with a right schema for my stored
procedure like

ALTER PROCEDURE "DBA"."testing"(
in iTest char(1)

BEGIN
if iTest= 'Y' then
select column1 as A from testA(iTest)
else
select column2 as A from testA(iTest)
end if;
end


Rob V [ Sybase ] Posted on 2009-11-27 08:48:15.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <77bee380-d9bf-4e6b-a7d2-299c0cf59716@m3g2000yqf.googlegroups.com>
Subject: Re: %1 returned a result set with a different schema than expected
Lines: 43
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0f924f@forums-1-dub>
Date: 27 Nov 2009 00:48:15 -0800
X-Trace: forums-1-dub 1259311695 10.22.241.152 (27 Nov 2009 00:48:15 -0800)
X-Original-Trace: 27 Nov 2009 00:48:15 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28701
Article PK: 77942

Looks like your question is about SQL Anywhere. This newsgroup is about ASE.
Try sybase.public.sqlanywhere.general instead.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"janis" <janimie@gmail.com> wrote in message
news:77bee380-d9bf-4e6b-a7d2-299c0cf59716@m3g2000yqf.googlegroups.com...
> Hi, iam getting the next error: %1 returned a result set with a
> different schema than expected
> Where can i find the result set with a right schema for my stored
> procedure like
>
> ALTER PROCEDURE "DBA"."testing"(
> in iTest char(1)
>
> BEGIN
> if iTest= 'Y' then
> select column1 as A from testA(iTest)
> else
> select column2 as A from testA(iTest)
> end if;
> end
>