On Monday 25 September 2006 15:05, Bob wrote:
> I would like to use autonomous transactions for a large batch process and I
> want this all encapsulated within stored procedures. I want to commit after
> say every 15,000 records. The only way I have found to do this is to use
> the perl DBI in my s
On Sep 25, 2006, at 3:05 PM, Bob wrote:
One issue I see with my current DBI solution is I need to hard
code or pass in as variables the connection information. I would
prefer not to have the password lying around in plain site. Keep
in mind this is a batch process not a something I that i
I would like to use autonomous transactions for a large batch process and I want this all encapsulated within stored procedures. I want to commit after say every 15,000 records. The only way I have found to do this is to use the perl DBI in my stored procedure to establish a new connection to the
