OpenVMS: ORA-22993 Using DBMS_LOB Package.

(Doc ID 412239.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
***Checked for relevance on 21-Jun-2013***


When attempting to load the contents of a bfile into a blob using the dbms.lob package from a sqlplus session:-

dbms_lob.getlength returns wrong file length
so dbms_lob.loadfromfile fails with ora-22993

The files are generated via a C program,on a HP OpenVMS machine and then FTP'd in Binary to the database server.


This problem is only seen on the OpenVMS platform.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms