Problem with debugging

[azp74]

Hi

I'm trying to test a stored procedure (which is called by another stored procedure).

Having declared rpk in the declare block I then issue some SQL:

select pk into rpk from sds.relationships_int where (mtr = pk and mtrversion = ver);

pk and ver have been passed in to the stored procedure and when I hover the mouse over them they have the right values.

When I execute this SQL it returns the expected value but when it's executed by the stored procedure it jumps straight to my exception handler for no_data_found.

I know this is not a problem with sessions and commits (I can connect/disconnect through lots of SQL*Pluses, query the table and always get the same result) but I can't work out why I'm not getting my expected result.

I am using Oracle 10gR2 (on WinXP) and PL/SQL Dev 6.0.6.947 01.26933 (also on WinXP) - should this work without displaying this strange behaviour?

Thanks
Alex

 

[azp74]

Sorry - various combinations of closing PL/SQL Dev, restarting my machine, completely recreating my database etc etc appear to have fixed this problem.

Alex