The stored procedure '# PN_SESSION_3_PROC' was not found

Question

Hi,

I have a temp procedure for sessions. Its working fine until now. the code as given below. For some front-end application users complianing that its not working for them and for some other users it works fine. Is that any permissions issue or any space issue?. This error (The stored procedure '# PN_SESSION_3_PROC' was not found )  occurs when added data from frontend application (delphi). While inserting this records you get this error.

  Create Procedure PN_SESSION_REDUN
  --
  --
    @p_return VarChar(1) Output
    -- Returns TRUE (T) to state 'updatecount will be increased at redundant update' ; this is DEFAULT behaviour!
    -- Returns FALSE (F) to state 'updatecount will be NOT increased at redundant update'
  As
  Begin
    Declare @l_retstat Integer
    Declare @l_vardeclared Varchar(1)
    Execute @l_retstat = # PN_SESSION_1_PROC 'OPT_UPDATECNT_AT_REDUN', @l_vardeclared Output
    If @l_retstat <> 0 Return @l_retstat
    If @l_vardeclared = 'F'
    Begin
      Execute @l_retstat =# PN_SESSION_2_PROC 'OPT_UPDATECNT_AT_REDUN'
      If @l_retstat <> 0 Return @l_retstat
      Execute @l_retstat = # PN_SESSION_3_PROC 'T'
      If @l_retstat <> 0 Return @l_retstat
    End
    Execute @l_retstat = # PN_SESSION_4_PROC @p_return Output
    If @l_retstat <> 0 Return @l_retstat
    Return
  End

 

Thanks in advance,

santosh

 

Answer 1

Is there really a space between the # and the rest of the name.   From above: # PN_SESSION_1_PROC

Normally a procedure could be referred to as #PN_SESSION_1_PROC  (with no space) or [# PN_SESSION_1_PROC] with the square brackets allowing the space to be in the name.

Perhaps some of the code is not in synch, so that the procedure name is not consistent throughout.

Just for what it is worth,

RLF