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.