1. Paul Dzuba
  2. PowerBuilder
  3. Wednesday, 4 October 2017 20:07 PM UTC

Just converted from PowerBuilder 6.5 and the OUTPUT parameter is not working with SQL. I get the following error and any help would be appreciated: SQLSTATE = 42000 Microsoft SQL Native Client Cannot use the OUTPUT option when passing a constant to a stored procedure. DBPARM: TrustedConnection=1,Database='MfgInfo',Provider=SQLNCLI11,DisableBind=0,PBNewSPInvocation='Yes',appname='MfgDisp',host='pmdzuba',Secure=1 CODE: string value long rc declare dynproc procedure for app_option_read @appname = :app_name, @appuser = :app_user, @keyname = :key_name, @valuename = :value_name, @default = :default_value, @value = :value OUTPUT using sqlca; execute dynproc;

Luiz Ribeiro Accepted Answer Pending Moderation
  1. Thursday, 5 October 2017 13:04 PM UTC
  2. PowerBuilder
  3. # 1

Hi Paul.

Maybe you will find a solution by changing the remote procedure call to include the owner.  e.g.:
subroutine rpc_sp_g_get_dbms_system_datetime (ref datetime dtm_DBMS_DateTime) RPCFUNC ALIAS FOR "dbo.sp_g_get_dbms_system_datetime"

http://codeverge.com/sybase.powerbuilder.database/stored-procedure-calls-from-pb-1/824655

Regards,

Luiz

Comment
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.