RDO connection to ORACLE database through ODBC string literal too long 
Author Message
 RDO connection to ORACLE database through ODBC string literal too long

I'm adding data to a bunch of tables in an oracle database with an
rdoConnection using .execute like so:

        strInsert = "INSERT INTO table1(table_title) " & _
            "VALUES ('" & strSomeValue "')"

        rdoCon.Execute (strInsert)

This works fine for most of the data, but occasionally I have string data
that is much larger than 255 characters.

If I am using access as my database, everything goes swimmingly.

My customer, however, is using Oracle 7. It seems that Oracle limits string
literals in SQL statements to 255 characters.

I'm getting Oracle error 1704 - String Literal too Long when inserting.

Is there any way around this that doesn't involve truncuating the data?

Thanks for the help!

--Phil Gross
  Consulting Engineer
  ServiceSoft Corporation

Mon, 02 Oct 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VB/RDO Oracle Application accessing Oracle database over PPP connection

2. DAO and ADO connection for ODBC Oracle Databases

3. connection string to oracle database

4. HELP on connection to Oracle with Microsoft ODBC for Oracle Driver

5. ODBC Connection Strings for LDAP<->ODBC in Visual Basic for MS Access

6. Can't open Oracle database with DAO35 and Oracle-ODBC

7. ?Oracle Date/Time and RDO/ODBC

8. BIIIIIIIG Problem using Oracle / ODBC / RDO

9. Problem using VB 4.0, RDO 1.0b, Visigenic 32bit ODBC and ORacle 7.2

10. RDO And Oracle Odbc Driver.

11. Failed to get RDO working with Oracle ODBC

12. RDO-ODBC vs. Oracle Objects


Powered by phpBB® Forum Software