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.

Updates in stored procedures

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 21:45:32.0Z
Paul Mapstone Posted on 1997-06-09 14:05:16.0Z
Message-ID: <339C0D9C.64DA@t-mi.com>
Date: Mon, 09 Jun 1997 15:05:16 +0100
From: Paul Mapstone <paul.mapstone@t-mi.com>
Organization: Tokyo-Mitsubishi International
X-Mailer: Mozilla 3.0C-NSCP (WinNT; I)
MIME-Version: 1.0
Subject: Updates in stored procedures
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:712
Article PK: 252464

When I do an INSERT/UPDATE/DELETE inside a stored procedure I get the
SQLWarning "An unexpected status value was received and ignored.". The
problem appears when using the execute() method, and is easily
reproduced using the IsqlApp demo. e.g.

CREATE TABLE X(i int)
go
CREATE PROC ins_X @i int AS INSERT X VALUES (@i)
go
ins_x 1
go

I have tried the 30May trial download and get the same problem.
I am using SQL-Server 11.0.2.1.

Comments?


David Clegg Posted on 1997-07-30 21:45:32.0Z
Message-ID: <33DFB5FC.2ECCB285@sybase.com>
Date: Wed, 30 Jul 1997 14:45:32 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Paul Mapstone <paul.mapstone@t-mi.com>
Subject: Re: Updates in stored procedures
References: <339C0D9C.64DA@t-mi.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:430
Article PK: 252182

If you execute your stored procedure using a CallableStatement
then it won't be suprised by the return-status from the stored
procedure's execution and you will not get the SQLWarning.

It is safe to ignore this warning.

dave

Paul Mapstone wrote:
>
> When I do an INSERT/UPDATE/DELETE inside a stored procedure I get the
> SQLWarning "An unexpected status value was received and ignored.". The
> problem appears when using the execute() method, and is easily
> reproduced using the IsqlApp demo. e.g.
>
> CREATE TABLE X(i int)
> go
> CREATE PROC ins_X @i int AS INSERT X VALUES (@i)
> go
> ins_x 1
> go
>
> I have tried the 30May trial download and get the same problem.
> I am using SQL-Server 11.0.2.1.
>
> Comments?