Insert Data into an Oracle Long Column

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
jay polam

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
If you use a long (large text) column in oracle database tables, you cannot insert more than 4000 characters using SQLPLUS. Using this code, you can insert up to 32000 characters. See the readme file for instructions regarding what to change to make this work in your case.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download oracle_procedure.zip