In prior versi0n of the Oracle database (12, 19c, 21c) when invoking ORA_SFT.LIST_EX the internal conversion from Java data type to PL/SQL type was working without any issues. With Oracle 26ai when invoking the ORA_SFTP function from another schema, the following error occur: ORA-00932: expression is of data type an object that could not be […]
Oracle
OraSFTP with support for AES – GCM encryption
The newest release of OraSFTP 1.5.2.21 now supports the SFTP encryption algorithms: aes128-gcm@openssh.com aes256-gcm@openssh.com both part of the AEAD encryption schema. This allows exchange of sensitive data from within onpremise Oracle databases right into remote SFTP and FTP/S locations without touching the file system. All existing customers with active subscription can upgrade if their partners […]
OraPGP with support for Autonomous database
With the emerging Oracle Cloud and more and more organizations migrating their on premise databases to the Autonomous database variant, we have made attempts to deploy OraPGP there too in order to offer a PGP cryptography solution there. At last we have successfully deployed it, by performing a set of additional steps which unfortunately are […]
OraSFTP 1.4.9.9 with fix in ZLIB compression mode
As of version 1.4.9.3 released in August 2021 DidiSoft OraSFTP offered ZLIB compression which greatly increased the speed of the SFTP communication. Unfortunately, the ZLIB package we used (JZlib) had a bug that resulted in ArrayIndexOutOfBoundsException on random occasions. This is very strange as this is the only Java ZLIB package with partial flush capabilities […]
Log4J Zero day vulnerability status report
Recently was discovered the Log4J zero-day vulnerability. We have inspected the code base of our products and below is a status report regarding the Log4J 0-day bug. OpenPGP Library for Java/OpenPGP Library for Android No references to Log4J found OpenPGP Library for .NET/OpenSSL Library for .NET No references to Log4J found OraSFTP No references to […]
OraSFTP – Critical update for OCT 2020 PSU patch
With the October patch OCT 2020 PSU, Oracle has changed the internal JVM contained in the Oracle Database from version JDK 1.6 to JDK 1.7. Unfortunately, a statically initialized field from a nested class was affected by the modified behavior of the Java runtime in version 1.7. An indication of this fatal behavior is when […]
Recent updates in the Oracle PL/SQL extensions product line (April)
OraSFTP OraSFTP is now in version 1.4.7 with recent enhancements being a fix for connecting to SFTP server FileMage Gateway located on Azure and a new method that allows setting remote file permissions. OraRSA OraRSA has been updated to version 1.3.4 with a different set of setup files for Oracle 11-18 and Oracle19. A set […]
New authentication methods in OraSFTP
OraSFTP version 1.4.5 adds support for Elliptic Curve based SFTP key exchange and public-key signatures. The complete list of new cryptography enhancements in this version is available below: Key exchange (KEX) An SSH session begins with a cryptographic exchange based on asymmetric cryptography algorithms, in order for the client and the server to agree on […]
OraRSA with CMS cryptography, OraSFTP with WGET
In the past few months, we have released a couple of updates to both OraRSA and OraSFTP. OraRSA The newest version of OraRSA now provides CMS (Cryptography Message Syntax) support. Encrypting, signing, decrypting and verifying CMS data is now supported from PL/SQL. OraSFTP Custom timeout adjustment is now possible when establishing an SFTP connection. A […]
java.sql.SQLException: ORA-00942 and ORA-02002
ORA-00942 : table or view doesn’t exist When loading one of our addon products for the Oracle© Database, with the loadjava tool, you may encounter the error: java.sql.SQLException: ORA-00942: table or view doesn’t exist The reason for the above error is that the schema (database login account) under which the loadjava must store the JAR […]
