Resolution:
This is a problem with the data direct driver and is explained by them as below.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The SQL that we generate for SQLProcedureColumns does execute slower than Oracle's because we are providing additional functionality.  Our catalog function will return SYNONYMS and Oracle's will not.

You can disable this functionality in our driver by turning off "Catalog Functions Include Synonyms".  This can be found on the 'Advanced' tab of the 4.1 driver and on the 'Performance' tab of the latest 4.2 driver.  Once this has been done, the SQL that the driver creates is much smaller and more like that created by the Oracle driver.

On Unix the setting is "CatalogIncludesSynonyms".  To turn it off, set it to 0
-----------------------------------------------------------------------------------------------------------------------

Why does ADB take a long time to invoke stored procedures in request/reply mode