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
Then create the procedure:
CREATE OR REPLACE PROCEDURE UI_SURVEY(
SURVEYID1 IN VARCHAR, TBDAT1 IN DATE)
Be the first to leave a comment
You must be Logged on to comment or reply to a post.