Error in Java- Parameter was not defined for Stored Procedure

• anjali.vishwakarma

  Ten Centuries

  Points: 1112

  More actions

  March 3, 2009 at 10:56 pm

  #131425

  My SP is as below

  create procedure ProcGetUserDetails

  @user_id varchar(40),

  @error_code int OUTPUT,

  @error_message char(255) OUTPUT

  begin

  SET NOCOUNT ON;

  BEGIN TRY

  select * from users where user_id = @user_id

  SET @error_code=0

  SET @error_message = 'Success'

  SET NOCOUNT OFF

  RETURN

  END TRY

  BEGIN CATCH

  BEGIN

  SET @error_code=ERROR_NUMBER()

  SET @error_message = ERROR_MESSAGE()

  RETURN

  END

  END CATCH

  end

  When calling this SP from Java gives error "Parameter user_id was not defined for Stored Procedure ProcGetUserDetails"

  Surprisingly this error doesn't appear everytime. It appears sometimes and mostly when the DB is blank, that is there is no data in the DB. And after restarting the application, it starts working properly. So what could be the problem ? Is it JDBC driver problem ? Has anyone faced this problem ?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 4, 2009 at 7:47 am

  #953205

  There doesn't appear to be anything in the SP that would create an error, so, yes it does sound like a java or jdbc problem. I'd ask you to post the Java code, but since I don't program in Java I probably wouldn't be able to help, but then again maybe somebody else can.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question