• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Powerscript code stops after the execution of stored procedure.

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

Resolved Powerscript code stops after the execution of stored procedure.

  1. Issue
0
Votes
Undo
  1. Louis Mancini
    Louis Mancini
  2. PowerBuilder
  3. 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.

 

FlexNet 2.4 Question
Themes not working under Window 7 Pro after build
Responses (1)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 June 2019 08:01 AM UTC
  2. PowerBuilder
  3. # 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
  1. Michael Kramer
  2. 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.
  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.