1. Pratibha Rawat
  2. PowerBuilder
  3. Friday, 9 April 2021 12:57 PM UTC

Hello,

We are facing issue with  SQLDA.GetDynamicString().

We are creating dynamic SQL and trying to read a value from a string 'ls_input' ( 30000 characters) but  SQLDA.GetDynamicString() is giving us only 16385 characters. 

 

Sample code: 

String outputString

SELECT Message1|| Message2 || Message3 INTO :ls_input  FROM dual

DECLARE ltest_cursor DYNAMIC CURSOR FOR SQLSA ;
PREPARE SQLSA FROM :ls_input USING sqlca;
DESCRIBE SQLSA INTO SQLDA ;
OPEN DYNAMIC ltest_cursor USING DESCRIPTOR SQLDA ;

FETCH ltest_cursor USING DESCRIPTOR SQLDA ;
CLOSE ltest_cursor;

 

for i = 1 to SQLDA.NumOutputs
choose case SQLDA.OutParmType[i]

case TypeString!
outputString= SQLDA.GetDynamicString(i)
end choose

next

This 'outputString' variable is giving me 16385 characters only. 

Also If we want to read the value from CLOB column how can we read the value using dynamic sql.  

Is there any character length limitation or any configuration in SQLDA.GetDynamicString which is not allowing us to read more that 16385 characters. 

Please advise ASAP. 

mike S Accepted Answer Pending Moderation
  1. Friday, 9 April 2021 14:41 PM UTC
  2. PowerBuilder
  3. # 1

Oracle?  

Comment
  1. Pratibha Rawat
  2. Friday, 9 April 2021 14:43 PM UTC
Oracle 19 C
  1. Helpful
  1. Miguel Leeuwe
  2. Friday, 9 April 2021 14:44 PM UTC
I guess you're thinking of that Oracle option that allows up to 30000 characters in a varchar2 ?
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 9 April 2021 13:29 PM UTC
  2. PowerBuilder
  3. # 2

What version of PB?

Comment
  1. Pratibha Rawat
  2. Friday, 9 April 2021 14:30 PM UTC
Version 2019 Build R2 2353
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 9 April 2021 14:54 PM UTC
Please open support ticket and provide a test case. Our support team will confirm if this is unsupported feature or there is bug.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 9 April 2021 15:41 PM UTC
Please open a support ticket as Armeen suggests. This sounds like an old size restriction from the days when PB was 16bit in nature.
  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.