ORA-01461: can bind a LONG value only for insert into a LONG column

0 Likes

Problem:

ORA-01461: can bind a LONG value only for insert into a LONG column

Resolution:

Information in this Brief applies to:

  • StarTeam 5.3
  • Windows 2000, NT, XP
  • Oracle 8i or 9i

Problem

When creating a change request in StarTeam, users are unable to enter input under the Description and Solution tabs. User gets the following error "ORA-01461: can bind a LONG value only for insert into a LONG column"

The problem is due to the wrong version of the Oracle ODBC driver being installed. If you go to Control Panel->Administrative Tools->ODBC_>Drivers tab, the Oracle driver should be one of the three:

8.01.07.89 for Oracle 8.1.7

9.00.01.64 for Oracle 9.0.1

9.02.00.43 for Oracle 9.2.0

The specific versions need to match exactly. If you don"t have the same version, follow the below instructions:

1. Shutdown the StarTeam Server 5.3 SP1

2. Download the Oracle driver from Oracle"s website: Download one of the following:

8.1.7.8b.0 for Oracle 8.1.7

9.0.1.6.0 for Oracle 9.0.1

9.2.0.4.0 for Oracle 9.2.0

3. Once you download the driver, execute the downloaded file and it will extract a few folders and files. Launch the Oracle Universal Installer and when you run Oracle"s Universal Installer, browse to this directory and under the "Disk1" folder is the "products.jar" file that the Universal Installer is looking for. Proceed to install this driver which will uninstall your current version. (Make sure it says that the driver is installed successfully)

4. After the Oracle driver is installed, verify the driver version in ODBC. It should be one of the versions listed in step#2.

5. Install the StarTeam patch for the driver. This patch can be found on the StarTeam CD under the "Patched Oracle ODBC Drivers" folder. All you have to do is copy the "sqora32.dll" file for the specific version into Oracle home"s "bin" directory. This will replace the current dll.

6. Go back to Control Panel->Administrative Tools->ODBC and the Oracle driver should now say "8.01.07.89" for 8.1.7, "9.00.01.64 " for 9.0.1 or "9.02.00.43" for 9.2.0.

7. Recreate the System DSN to now use the this new Oracle ODBC driver.

8. Launch StarTeam ServerTools by going to Start->Programs->StarTeam->StarTeam Server.

9. In ServerTools, click on "properties" button for your server configuration and make sure you can verify database connection under the "Database Connection Information" tab.

10. Start the StarTeam server 5.3 SP1.

11. Try to create a CR with the description and comment fields filled out.

Old KB# 28439
Comment List
Related
Recommended