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

Resolved Empty String in Appeon Server and Oracle 19c

  1. Issue
0
Votes
Undo
  1. Jon Tzeng
    Jon Tzeng
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 15 March 2021 16:05 PM UTC

We have Oracle 19c database and PowerServer 2020. We found an external function called by Oracle package with return as a space the, the PowerServer 2020 seems it would return as an empty string instate of a space. We don't see that happen when running on PowerBuilder 2019 R3. This empty string would cause the table update failed because the field cannot be null.

 

Fail to generate dwsql
Datawindow button image is not display
Responses (3)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 March 2021 02:47 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Jon,

The space issue is caused by the workaround of another issue in PowerServer 2020. Please try working around this issue by replacing the empty string with a space in PB script.

The traditional PowerServer uses the Microsoft built-in ‘System.Data.OracleClient’ which is being deprecated by Microsoft. This OracleClient has stored proc return value truncation issue, and this is an Oracle bug 【Bug 21616079】. You may refer to the below link for more information:
https://stackoverflow.com/questions/28508440/microsoft-iis-8-5-oracle-output-variables-are-truncated

PowerServer 2020 works around the issue when you select DB type 'Oracle 18C/19C'. This workaround only affects the varchar/varchar2 type parameters of the stored procedure.
We have done such kind of test and the only problem we found is that the space at the end of the return value of the varchar/varchar2 type parameters that the stored procedure outputs will be deleted. Everything works well except that.

Regards,
ZhaoKai

Comment
Jon Tzeng
  1. Jon Tzeng
  2. Wednesday, 17 March 2021 10:18 AM UTC
Thank you for the information. Does Appeon have any plan the fix the Oracle bug in PowerServer?
  1. Helpful
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Thursday, 18 March 2021 03:27 AM UTC
Hi Jon,



Sorry that currently there is no detailed plan to fix it in PowerServer 2020. You can select DB type 'Oracle 10g/11g/12c' and install Oracle 11G client to resolve the issue.



BTW, PowerServer 2021 will fix the issue. In the new generation of PowerServer, essentially 100% of PowerBuilder features are supported.



You can refer to the following link for more information on PowerServer 2021:

https://community.appeon.com/index.php/blogs/recent-blogs/new-deployment-options-coming-soon



Regards,

ZhaoKai

  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 16 March 2021 18:17 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Jon,

Unless your project is almost finished with the conversion, I recommend using PowerServer 2021 over 2020 version because it is light years ahead.

Here are the top 5 advantages of the 2021 version:

  1. Supports ~100% of PowerBuilder features
  2. Cloud-native architecture that is compatible with cloud providers, Docker, etc.
  3. Much stronger security, such as app encryption, integrity checking, SQL protection, OAuth 2.0 security, etc.
  4. Supports .NET Core 3.1 (instead of old .NET framework) so server can be Linux or Windows
  5. Lower price with new subscription option (in addition to perpetual)

Here is a detailed whitepaper that contrasts the technical differences between the two versions: https://docs.appeon.com/whitepapers/Whitepaper_Deploying_PowerBuilder_Apps_to_the_Cloud.pdf

We currently have a Pre-Beta version available which you may test. We invite you to write to us at trial@appeon.com to schedule a short training and obtain this version for testing.

Best regards,

Armeen Mazda
CEO, Appeon

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 15 March 2021 18:35 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

In oracle, an empty string: "" is NULL in a varchar2 column.

you have to set the value to a single space if you don't want it to be null.

Comment
Jon Tzeng
  1. Jon Tzeng
  2. Tuesday, 16 March 2021 15:22 PM UTC
I found out the the return from oracle package function with a space in PowerServer would return as empty space instead of a space. I update my questions.
  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.
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.