1. Aleš Vojáček
  2. PowerBuilder
  3. Friday, 26 January 2024 14:24 PM UTC

Hi all,

I'm using RPC to call MSSQL stored procedures.

local externa function on transaction object 

function long PORADI_DNE(datetime DATUM,ref int SEKVENCE) RPCFUNC ALIAS FOR "dbo.PORADI_DNE"

If there is 

raiserror ('Error from procedure',3,1)

in procedure.

I have no Error in SQLCA

sqlca.sqlcode is 0 and no error text.

What I have to do in order to get raised error into PowerBuilder?

 

Thank you Ales.

P.S. I'm using PB2022 + DBMS "MSOLEDBSQL SQL Server"  

Accepted Answer
Aleš Vojáček Accepted Answer Pending Moderation
  1. Friday, 26 January 2024 15:48 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi all,

the problem was that I used too low severity, if I use severity 12 it propagates to our powerbuilder app.

Ales

Comment
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.
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.