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.