java.sql.SQLException: ORA-06550 exception in JDBC step

Products

• Service Virtualization

Issue/Introduction

There is a virtual service which is working fine in v10.3 but not working in DevTest v10.6 after migration.

The issue is with Virtual service giving error "ORA-06550" when it executes JDBC step.

Query:

BEGIN 
STATIC('1111111111','2222222222','23-Nov-2021');
END;

Connection String: jdbc:oracle:thin:@IP address:1522/DB_name

Error:

java.sql.SQLException: ORA-06550: line 2, column 1:
PLS-00201: identifier 'STATIC1' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

Environment

Release : 10.6

Component :

Cause

We can't be sure about the reason of failure because this is a scenario of customized model with extra non-VSE steps added to it.

By non-VSE, it means the steps that are not present then the model is generated by the tool or the steps other than those present inside "Virtual Service Environment" category of steps.

Development doesn't test/certify such scenarios and such compatibility situations are expected.

Resolution

The issue was resolved after amending all database steps to "Generate Error" instead of re-directing next step to "Error Handling" step in that VSM.