|
View previous topic :: View next topic
|
| Author |
Message |
Nithya Usha Mohanan
New User
Joined: 16 Oct 2007
Posts: 7
Location: pune
|
|
|
|
Hi ,
I am getting compilation error in the db2 stored procedure when i am trying to concatenate messages in the out varchar variable P_message .
set p_message = p_message || 'loads data' ;
here i am trying to append string 'loads data' to the already existing data in p_message.
the below statement is also giving compilation error.
set p_message = p_message || 'number of updated rec' || l_counter ;
here i am trying to concatenate number of updates rec to the already existing data in p_message and the value of l_counter which is calculated in the stored proc.
i am not able to understand why this is giving compilation errors. please help.
regards,
Nithya |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| Could you please tell us the exact error message & code? |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
| Back to top |
|
|
|
|
