Hi
I am working on unit testing ,
I have one issue I have to check that programmer is used cursor or not and also all the cursor that he have used
I have to use jdbc code for.
pls help me as soon as possible
You need to be SYS to access those views in the system tablespace.
You should look those up in your oracle documentation. It has nothing to do with Java.
If you're planning on trying to check all the cursors have been closed, you won't succeed. Oracle caches some, so you won't be able to tell if there's a leak that way, as far as I know...
That's why I didn't suggest that they look in v$open_cursor instead.
They could tell about the leak using these methods if they are very clever and rigorous but the attitude they have shown so far suggests that they will not.
Good article, but it does (sort of) agree with what I said about it being not really doable (at least as an automated thing). I did, however, get my terminology wrong. I thought it was down to the cacheing, but it's simply down to Oracle not closing cursors straight away.
I say automated, since they're talking about unit testing...and I would lay odds on that being JUnit. This is a hands on check and, arguably, doesn't lend itself to the sorts of things JUnit handles.
Plsql cursor jdbc
Linear Mode
