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.

pb651调用ORACLE存储过程的问题

2 posts in General Discussion (Chinese) Last posting was on 2006-09-01 07:09:11.0Z
lpss Posted on 2006-09-01 02:20:24.0Z
Sender: 8f3.44f798bd.1804289383@sybase.com
From: lpss
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: pb651调用ORACLE存储过程的问题
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44f798e8.8f5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Aug 2006 19:20:24 -0700
X-Trace: forums-1-dub 1157077224 10.22.241.41 (31 Aug 2006 19:20:24 -0700)
X-Original-Trace: 31 Aug 2006 19:20:24 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:108
Article PK: 104154

&#22312;ORACLE815&#20013;&#26377;&#19968;&#23384;&#20648;&#36807;
&#31243;&#65288;&#22312;&#21253;PK_TEST&#20013;&#65289;
procedure p_test(para1 in boolean, para2 in boolean)
&#22312;PL/SQL&#19979;&#27979;&#35797;&#25104;&#21151;
execute p_test(true,false);
&#22312;PB651&#20013;&#22768;&#26126;&#35813;&#36807;&#31243;
&#26102;&#20986;&#29616;&#32534;&#35793;&#38169;&#35823;&#65306;
DECLARE my_test PROCEDURE FOR pk_test.p_test(true,false);
Errors:
(0014):Database C0038: Invalid stored procedure parameter
type of 'BOOLEAN' on 'PARA1'
&#35831;&#38382;&#65292;&#36825;&#26159;&#20160;&#20040;&#38382;
&#39064;&#65292;&#35813;&#22914;&#20309;&#35299;&#20915;&#12290;


hni Posted on 2006-09-01 07:09:11.0Z
Sender: 54d1.44f7cc42.1804289383@sybase.com
From: hni
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Re: pb651&#35843;&#29992;ORACLE&#23384;&#20648;&#36807;&#31243;&#30340;&#38382;&#39064;
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44f7d9ef.554b.1681692777@sybase.com>
References: <44f798e8.8f5.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 31 Aug 2006 23:57:51 -0700, 10.22.241.42
Lines: 18
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 Aug 2006 23:57:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Sep 2006 00:09:11 -0700
X-Trace: forums-1-dub 1157094551 10.22.108.75 (1 Sep 2006 00:09:11 -0700)
X-Original-Trace: 1 Sep 2006 00:09:11 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:109
Article PK: 104153

&#35831;&#21442;&#32771;&#24110;&#21161;&#20013; “DECLARE
Procedure SQL statement”

> &#22312;ORACLE815&#20013;&#26377;&#19968;&#23384;&#20648;
> ;&#36807; &#31243;&#65288;&#22312;&#21253;PK_TEST&#20013;
> ;&#65289; procedure p_test(para1 in boolean, para2 in
> boolean) &#22312;PL/SQL&#19979;&#27979;&#35797;&#25104;
> ;&#21151; execute p_test(true,false);
> &#22312;PB651&#20013;&#22768;&#26126;&#35813;&#36807;
> ;&#31243; &#26102;&#20986;&#29616;&#32534;&#35793;&#38169;
> ;&#35823;&#65306; DECLARE my_test PROCEDURE FOR
> pk_test.p_test(true,false); Errors:
> (0014):Database C0038: Invalid stored procedure parameter
> type of 'BOOLEAN' on 'PARA1'
> &#35831;&#38382;&#65292;&#36825;&#26159;&#20160;&#20040;
> ;&#38382; &#39064;&#65292;&#35813;&#22914;&#20309;&#35299;
> ;&#20915;&#12290;