Check for dbms_crypto access fails on Oracle 10.2

Toad for Oracle - Beta
1

I wanted to compare the data in a table that has a CLOB column.
Toad uses the following statement to check whether access to dbms_crypto is permitted:

select sys.dbms_crypto.Hash(src=>to_clob('x'), typ=>3) from dual;

At least in Oracle 10.2, named procedure parameters are not supported in SQL.

2

Thanks. I can reproduce that and will fix.

As a workaround:

  1. go back to the "choose tables" step
  2. click the "options" tab
  3. under "features" check "display advanced features" and "Compare LOBs by length only"

It's not a perfect comparison, but it's better than nothing.