• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Failed to parse the statement ‘My_Package_1.sp_my_procedure_poc’: The function or stored procedure might not exist.

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

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

  1. Issue
0
Votes
Undo
  1. Saravanan A L
    Saravanan A L
  2. PowerServer
  3. Monday, 21 October 2024 14:50 PM UTC

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

Getting Error converting datatype nvarchar to int ...
Need UPDATE Query submitted to DBMS during run tim...
Responses (3)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 22 October 2024 16:18 PM UTC
  2. PowerServer
  3. # 1

Hi Saravanan,

 

If you can submit the reproducible test case to the ticket you already submitted, I will re-open it.

 

Regards,
Francisco

Comment
There are no comments made yet.
David Xiong @Appeon
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 22 October 2024 07:26 AM UTC
  2. PowerServer
  3. # 2

Hi Saravanan,

 

Using the wrapper procedure is just a temporary workaround before the issue is addressed in the product. We recommend that you submit a ticket at https://www.appeon.com/standardsupport/newbug and provide a reproducible test case to help us analyze and reproduce this issue. If we can confirm the problem, we can consider fixing it in a future version, so you won’t need to use the wrapper procedure as a workaround.

 

Regards, 

David

Comment
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Monday, 21 October 2024 16:46 PM UTC
  2. PowerServer
  3. # 3

Hi Saravanan,

Can you link to the Community Post in question?

 

Regards,
Francisco

Comment
Saravanan A L
  1. Saravanan A L
  2. Monday, 21 October 2024 17:31 PM UTC
You mean to say that the suggestion where i was referring? Here is the link i was referring ( https://community.appeon.com/index.php/qna/q-a/failed-to-parse-the-statement-execute-dbms-application-info-set-client-info)
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.