| Problem recording multiple CLOB using VB - ADO (merged) [message #477207] |
Wed, 29 September 2010 08:14  |
rcoltrane
Messages: 2
Registered: September 2010
|
Junior Member |
|
|
I have a program that was attached to an Access 2003 database but now I need to port it to an OracleXE database. I did the whole migration and it is working fine, except for some CLOB fields that are giving me an error.
I'm using ADO to retrieve/record data to OracleXE but when I try to record some data to one of my tables that has multiple CLOB fields, it gives me a Run-time error like this:
Run-time error '-2147467259 (80004005)'
Here's the code I'm using to record to the OraXE table:
With RS
.Open ("SELECT * FROM VAGAS"), DBConn, adOpenStatic, adLockOptimistic
.AddNew
!consultor = pblCodCon
!status_vaga = varCodStatVaga
!detvaga = txtDetVaga.Text
!qtde_vagas = txtQtdeVagas.Text
!tipo_vaga = varCodTipoVaga
!taxa_selecao = txtTXSel.Text
!ocorrencia = txtOcorrencia.Text
...
The CLOB fields here are !detvaga and !ocorrencia and when it start recording, the 1st CLOB field (detvaga) is recorded but when it reaches the 2nd CLOB (ocorrencia) it gives me that annoiyng run-time error from above.
Please help!
Thanks for reading.
Roger.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
