ni***********@gmail.com wrote:
Hi Frnds ,
I want to debug a stored procedure.
It is written in SQL. I am using Developement center for creating
stored procedures.
I built the stored procedure with Debug option and also performed BIND
operation.
When click on Debug menu and enter the Input parameters for the stored
procedure ,
i get folowing exception / error :
VL000039 - Debug started.
VL000039 - Exception occurred while debugging:
[IBM][CLI Driver][DB2] SQL0440N No authorized routine named
"DB2DEBUG.CREATE_SESSION" of type "" having compatible arguments was
found. SQLSTATE=42884
Friends , please help me ..
How many parameters does your procedure have, how many arguments do you
pass? I presume (since you created the routine) that you have EXECUTE
privilege on the procedure?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab