PI JDBC Stored Procedure test scenario

Recently we used stored procedures in the PI implementation project. It takes a lot of time to test and test and test.

We all know that, the parameters of stored procedures must be identical if you call it correctly. And what’s more we have to take into account in PI? I design the test scenarios to show you.

First create the table:

CREATE TABLE SURVEY(SURVEYID
varchar2(32),TBDAT date);

Then create the procedure:

CREATE OR REPLACE PROCEDURE UI_SURVEY(

SURVEYID1 IN VARCHAR, TBDAT1 IN DATE)