Re: ODBC Pass Through SQL to Oracle Express 10g

From: Greg Strong <news.REMOVE_at_geedubeeu.com.invalid>
Date: Mon, 03 Jul 2006 14:06:37 -0500
Message-ID: <90qia2piafqnvif3u0nhhncv2951cqcpmv@4ax.com>

On 3 Jul 2006 11:42:10 -0700, "joel garry" <joel-garry_at_home.com> wrote:

>Metalink Note:135313.1 says nested transactions are not supported with
>ODBC, and shows how to simulate with savepoints.

Are you referring to Oracle support info when stating "Metalink Note:135313.1"? If so, I do not have access to it.

Maybe I should ask what ODBC means when stating 'nested transactions'?

What the code does is simply use DDL which is defined in VBA to create a table. This is done 10 consecutive times. Maybe the fact it is done consecutively creates 'nested transactions'. I do not know. I can say that all VBA DDL code has been debug printed. I've subsequently copy and paste the SQL to SQLPLUS where all ran successfully. If consecutive running of code creates 'nested transactions' in ODBC, than I've learned something. Just grasping at straws. Thanks!

-- 
Regards,

Greg Strong

Received on Mon Jul 03 2006 - 14:06:37 CDT