467,106 Members | 1,286 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,106 developers. It's quick & easy.

Debugging SQL stored procedure using developement center

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 ..

Feb 28 '06 #1
  • viewed: 2239
Share:
3 Replies
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
Feb 28 '06 #2
The stored procedure takes 5 input parameters.
And i pass all 5 arguments.Also i have execute privilege on the
procedure

Feb 28 '06 #3
ni***********@gmail.com wrote:
The stored procedure takes 5 input parameters.
And i pass all 5 arguments.Also i have execute privilege on the
procedure

Can you call the procedure from command line?
db2 "CALL ....."

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Douglas Buchanan | last post: by
reply views Thread by Raquel | last post: by
reply views Thread by nikhilbhavsar@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.