Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 stored procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-01 : 07:38:41
Ramneet writes "Dear friends,
I am trying to call a stored procedure written in ms sql server 2000 on windows 2000 advanced server os (intel platform).it is just aa testing proc since my actual proc was not working
it's like
create procedure test
@val1 bigint,
@val2 bigint,
@val3 bigint output
as
select @val3=@val1 + @val2

my problem actually
starts when i call this procedure from jdbc using sql server thin clent driver for java....

i using prepare statement and callable statement object
as
execute test ?,?,?
i am able to send the values to proedcure but in returning values i get error unable to get requestred data.

How to call a stored procedure with in and out paramters and how to call a function fro JDBC (JAVA)
kindly help"
   

- Advertisement -