OraSFTP v 1.2.6 now supports current remote folder

DidiSoft OraSFTP prior to version 1.2.6 were limited to either absolute paths or paths relative from the current user remote home directory.

As of version 1.2.6 the current remote folder can be changed this way allowing for easy traversing and manipulation of complex remote folder structures.

The new methods that support this functionality are:

ORA_SFTP.CURRENT_DIRECTORY – retrieves the absolute path of the current remote folder

ORA_SFTP.PWD – alias of ORA_SFTP.CURRENT_DIRECTORY

ORA_SFTP.CD – changes the current remote folder

ORA_SFTP.CD_UP – changes the current remote folder one level up

You can see example usage at:

https://www.didisoft.com/ora-sftp/tutorial/#pwd

Read more...

OraRSA 1.1 offering various SHA based signings

DidiSoft OraRSA version 1.1 was released today. It offers to customize the digital signature algorithm in contrast to version 1.0 where only SHA1withRSA was available.

How to use the new algorithms?

In order to use the new algorithms, you must specify the algorithm needed as the last parameter of the ORA_RSA.SIGN and ORA_RSA.VERIFY methods. Available values are:

ORA_RSA.HASH_SHA1 for SHA1withRSA
ORA_RSA.HASH_SHA224 for SHA224withRSA
ORA_RSA.HASH_SHA256 for SHA256withRSA
ORA_RSA.HASH_SHA384 for SHA384withRSA
ORA_RSA.HASH_SHA512 for SHA512withRSA

Upgrade from version 1.0

In order to upgrade from version 1.0 you must first unload the version 1.0 JAR files:

dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\jce-jdk13-152.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\ora-rsa-1.0.0.jar

Then continue like a normal Setup.
 

Read more...

IdNotFoundException

Executing procedures from the dbms_java Oracle PL/SQL package may result in a strange IdNotFoundException like:

ORA-29532: Java call terminated by uncaught Java exception: oracle.aurora.vm.IdNotFoundException: user : user or role id does not exist

This is very common when granting java.io.FilePermission:

call dbms_java.grant_permission('user', 'java.io.FilePermission', 'C:/MyFolder/ora-pgp-1.1.0.jar', 'read');

If you experience such error try changing the user(schema) name to Uppercase.

Read more...