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.

Passing Null values to Stored Procedure

2 posts in JConnect version 3.0 Last posting was on 1999-03-31 12:13:38.0Z
Madan Chellu Posted on 1999-03-24 13:43:12.0Z
Message-ID: <36F8EBF0.F90E5DDB@prt.com>
Date: Wed, 24 Mar 1999 09:43:12 -0400
From: Madan Chellu <mchellu@prt.com>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Passing Null values to Stored Procedure
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:286
Article PK: 255720

Hi,

How can I pass Null values as parameters to the Stored Procedure through
JConnect using JDBC !


Lance Andersen Posted on 1999-03-31 12:13:38.0Z
Message-ID: <37021172.64B152E@sybase.com>
Date: Wed, 31 Mar 1999 07:13:38 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.51 [en] (X11; I; SunOS 5.7 sun4m)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Passing Null values to Stored Procedure
References: <36F8EBF0.F90E5DDB@prt.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:274
Article PK: 254590


Madan Chellu wrote:
>
> Hi,
>
> How can I pass Null values as parameters to the Stored Procedure through
> JConnect using JDBC !

This can be done via a PreparedStatement or a CallableStatement. If you
are having a problem, please provide a piece of sample code and a
*small* sproc that runs on its own (without requiring tables that you do
not supply)

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

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