Powerscript code stops after the execution of stored procedure.

Resolved Powerscript code stops after the execution of stored procedure.

Issue

Votes

Undo

Louis Mancini
PowerBuilder
Wednesday, 5 June 2019 19:25 PM UTC

Hi,

Recently migrated older PB12 code to PB 2017 R3 and also tried the new PB 2019 have this issue.

Powerscript code stops after the execution of an embedded stored procedure. None of the powerscript code after the stored procedure runs in executed. This use to work fine. DB is MS SQL server

Any way to fix this.

Thank You.

Responses (1)

Kai Zhao @Appeon Accepted Answer Pending Moderation

Thursday, 6 June 2019 08:01 AM UTC
PowerBuilder
# 1

Hi Louis,

Please add ",PBNewSPInvocation='yes'" at the end of SQLCA.DBPARM before connecting and see if it works.

If there’s still the issue, please help to provide a test case to us for more
study.

Regards,
ZhaoKai

Comment

Michael Kramer
Thursday, 6 June 2019 13:32 PM UTC

I have stored procedure calls working just fine in PB 2017 R3. Both using embedded SQL and using RPCFUNC declarations. Both using pass-by-value and pass-by-reference parameters.

As ZhaoKai points on, when SQLCA is configured correctly there should be no issues doing this.

Helpful 0

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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.