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 get the return value of the return(n) statement of a Stored procedure?

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-10-09 19:23:44.0Z
Chi-Ming Yang Posted on 1997-10-09 14:27:52.0Z
From: "Chi-Ming Yang" <jimy@smart.net>
Subject: How to get the return value of the return(n) statement of a Stored procedure?
Organization: BLS
Message-ID: <01bcd4c8$7ec4b6a0$642e8e92@species8472-psb.psb.bls.gov>
X-Newsreader: Microsoft Internet News 4.70.1162
Newsgroups: sybase.public.jdbcconnect
Date: Thu, 09 Oct 1997 10:27:52 -0400
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:183
Article PK: 251935

How to get the return value of the return(n) statement of a Stored
procedure? (Transact SQL)

I am using jConnect with Sybase System10.
I have Stored procedure that has return(1) statement.

Is there a way that I can get that return vaule using JDBC??

Thanks a lot.


Lance Andersen Posted on 1997-10-09 18:04:33.0Z
Message-ID: <343D1CB1.4A5E@sybase.com>
Date: Thu, 09 Oct 1997 14:04:33 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Chi-Ming Yang <jimy@smart.net>
Subject: Re: How to get the return value of the return(n) statement of a Stored procedure?
References: <01bcd4c8$7ec4b6a0$642e8e92@species8472-psb.psb.bls.gov>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 29
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:181
Article PK: 251933

In $JDBC_HOME/sample

You will find a jdk 1.1 applicatin called Callable and if you have
jConnect 2.2, there is also a program calld MyCallable

which will show you how to do this.


Also, in the future please use

news://forums.sybase.com/sybase.public.jconnect

for all future postings.

We will be marking this newsgroup read only shortly...

thanks


-lance

Chi-Ming Yang wrote:
>
> How to get the return value of the return(n) statement of a Stored
> procedure? (Transact SQL)
>
> I am using jConnect with Sybase System10.
> I have Stored procedure that has return(1) statement.
>
> Is there a way that I can get that return vaule using JDBC??
>
> Thanks a lot.

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


David Lance Wolf Posted on 1997-10-09 19:23:44.0Z
Message-ID: <343D2F40.3B62C1B4@sybase.com>
Date: Thu, 09 Oct 1997 12:23:44 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: How to get the return value of the return(n) statement of a Stored procedure?
References: <01bcd4c8$7ec4b6a0$642e8e92@species8472-psb.psb.bls.gov>
Content-Type: multipart/mixed; boundary="------------D444F1CB093C9118EC74E58F"
Newsgroups: sybase.public.jdbcconnect
Lines: 32
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:182
Article PK: 251934

Look into the CallableStatement interface. You should be able to
register a ? paramter for the return code.

Dave Wolf
Sybase Professional Services

Chi-Ming Yang wrote:
>
> How to get the return value of the return(n) statement of a Stored
> procedure? (Transact SQL)
>
> I am using jConnect with Sybase System10.
> I have Stored procedure that has return(1) statement.
>
> Is there a way that I can get that return vaule using JDBC??
>
> Thanks a lot.


Download VCard vcard.vcf