Hello,

We are using Powerserver 2022 and database is Oracle19c. After build and deploy the application and while executing the app , we are getting the following issue. We did debug and found that our app were using as follows:

DECLARE lp_create_poc PROCEDURE FOR My_Package_1.sp_my_procedure_poc (ip,op);

Failed to parse the statement ‘My_Package_1.sp_my_procedure_poc’: The function or stored procedure might not exist.

After going thro appeon community, it was suggested to use the warpper procedure to avoid this issue.

We created the wrapper procedure and the issue got resolved.

So, our questions is, whether we need to always create a wrapper procedure for all the cases where it is failing? as we have plenty in our product and it is not advisable to create wrapper procedure for all the cases. Is there any permanent solution without creating the warpper proc to work?

Regards,

Saravanan