Hi,

I used PowerBuilder 2021 (beta)  CacheName to connect different database dynamically during runtime.

I modify below DBParm ,

From:

 SQLCA.dbparm = "Release='12.5',staticbind=0,Charset='roman8'"

To

 SQLCA.dbparm = "Release='12.5',staticbind=0,Charset='roman8'"  + ",CacheName='" + trim(db_name) + "'"

But getting below error because my Stored Procedure is return varchar(1000). It worked fine before added the cachename.

B

CREATE PROCEDURE g_qaInitialize
   @comp_nr char(3)
  ,@plan_nr char(2)
  ,@ssn_nr char(9)
  ,@quest_key char(10)
  ,@called_by char(1)
  ,@description varchar(255) = NULL OUTPUT
  ,@jump_back char(1) = NULL OUTPUT
  ,@flow_ind char(1) = NULL OUTPUT
  ,@win_option char(1) = NULL OUTPUT
  ,@cancel_option char(1) = NULL OUTPUT
  ,@screen_width char(1) = NULL OUTPUT
  ,@cb_save_text varchar(10) = NULL OUTPUT
  ,@ErrorMessage varchar(1000) = NULL OUTPUT