Thanks Mark,

I changed the transactions property to 1 and the error message disappeared. I'll use the settings you sent, and test again.

Paul

>Here are my view and connection properties that differ from yours. My Transactions property is set to 1. You might also want to change the ShareConnection property to TRUE. I am also connecting to Oracle with no problems with the settings below.
>
>** View Properties
>
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'FetchSize', -1)
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'MaxRecords', -1)
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'ShareConnection', .T.)
>
>** Connection Properties
>
>DBSetProp('NPDES', 'Connection', 'BatchMode', .T.) && irrelevent?
>DBSetProp('NPDES', 'Connection', 'ConnectTimeOut', 15) && irrelevent?
>DBSetProp('NPDES', 'Connection', 'Transactions', 1)
>
>>Hi Mark,
>>
>>Thanks very much for having a look. Here is the dbsetprop code for view:
>>
>>
>>=DBSetProp('RV_PLSINS', 'View', 'UpdateType', 1)
>>=DBSetProp('RV_PLSINS', 'View', 'WhereType', 1)
>>=DBSetProp('RV_PLSINS', 'View', 'FetchMemo', .F.)
>>=DBSetProp('RV_PLSINS', 'View', 'SendUpdates', .T.)
>>=DBSetProp('RV_PLSINS', 'View', 'UseMemoSize', 255)
>>=DBSetProp('RV_PLSINS', 'View', 'FetchSize', 100)
>>=DBSetProp('RV_PLSINS', 'View', 'MaxRecords', -1)
>>=DBSetProp('RV_PLSINS', 'View', 'Tables', 'PLSINS')
>>=DBSetProp('RV_PLSINS', 'View', 'FetchSize', 100)
>>=DBSetProp('RV_PLSINS', 'View', 'Comment', "")
>>=DBSetProp('RV_PLSINS', 'View', 'BatchUpdateCount', 1)
>>=DBSetProp('RV_PLSINS', 'View', 'ShareConnection', .F.)
>>=DBSetProp('RV_PLSINS', 'View', 'Prepared', .F.)
>>=DBSetProp('RV_PLSINS', 'View', 'CompareMemo', .T.)
>>=DBSetProp('RV_PLSINS', 'View', 'FetchAsNeeded', .F.)
>>
>>I see the parameter list got truncated.
>>
>>I've added the code for the connection properties. The transactions is set to '0'. I wonder it that means anything.
>>
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection','Asynchronous', .F.)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'BatchMode', .F.)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Comment', '')
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'DispLogin', 0)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'ConnectTimeOut', 0)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'DispWarnings', .F.)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'IdleTimeOut', 0)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'QueryTimeOut', 0)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Transactions', 0)
>>=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Database', '')