Javelin - Calling Oracle Stored procedures with output parameters

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Is it possible with Javelin to call Oracle’ stored procedures with “output” parameters?

We’re trying with the OraclePLSQLActivity native component with the syntax suggested in the documentation but we get the error:

Connecting to Oracle database...

2025-03-24 13:51:13 - Executing query: begin p_test (999, ''); end;

2025-03-24 13:51:13 - Exception occurred executing query: ORA-06550: line 1, column 20:

PLS-00363: expression '<null>' cannot be used as an assignment target

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

2025-03-24 13:51:13 - Error executing OraclePLSQLActivity: ORA-06550: line 1, column 20:

PLS-00363: expression '<null>' cannot be used as an assignment target

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

We also tried defining the output parameter as “In/Out” but we get the same error.

Any suggestion to workaround this issue?

Environment

TDM 4.11.x

Javelin 4.11.x

Resolution

Currently the OracelPLSQLActivity is not supported with output parameters.