reset counter in reference cursor

oracle India
  • 13 years ago

    hi all,

    i am calling a sql proc through a java code. this sql proc outputs a reference cursor and a rowcount to the records in that cursor. the problem arises here as to calculate row count i need to execute a loop which brings counter in reference cursor to end so when through java this proc is called it skips the record set since counter is in the end and result only rowcount. if i comment out the loop in which rowcount is calculated i get the record set but not the count. i would be obliged if someone could propose a sol to this by either change in sql or java proc.

    thanks  

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - Rick Osborne