OpenVMS: ORA-22993 Using DBMS_LOB Package.
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 10.2.0.5 [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