On 03/02/2008 06:39, Sim Zacks wrote:
I call the function once it works, when I call it a second time, it gives me an error that the sequence already exists. When I restart the application, I can call the function again.
Are you by any chance connecting via ODBC with connection pooling? If so, then the pooled connections remain open, which - as someone else has explained - causes sessions to be maintained.
Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
