Stored procedure calls

[Guest]

I am calling a stored procedure in Oracle using VB.NET 2003. A function
calls the procedure every 15 seconds, by using a timer, to fill a dataset.

On first calling the procedure everything works as expected, however on
subsequent calls the procedure returns no new rows to add to the dataset.
But if I use a button to call the same function the procedure works again.
Further calls using the timer return no results.

Is there something in VB.NET that is stopping this procedure call from
working? Or is it something in Oracle? Or is it me? (most likely).

Thanks in advance.

 

[Guest]

Are you holding the connection open permanently or requesting a connection
object each time. If held permanently, you need to increase timeout (not a
wise direction to head, however). If new connection each time, I am not sure.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************