cancel
Showing results for 
Search instead for 
Did you mean: 

The formal parameter "@id" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

Former Member
0 Kudos

global type uo_customerfrom transaction  end type  global uo_customer uo_customer  type prototypes  FUNCTION long f_InsertCustomer  ( REF int al_id,REF string as_customer)  RPCFUNC ALIAS FOR 'spInsertCustomer'  end prototypes  type variables  end variables  on uo_customer.create  call super::create  TriggerEvent( this, "constructor" )  end on  on uo_customer.destroy  TriggerEvent( this, "destructor" )  call super::destroy  end on  //Script luo_customer luo_customer  luo_customer= create uo_customer  luo_customer.f_InsertCustomer  (li_id,ls_name)  // Here error is coming  Transaction not connected.  //Sqlserver Error SQLSTATE = 42000 Microsoft SQL Native Client The formal parameter "@id" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output. ALTER  PROCEDURE [dbo].[spInsertCustomer ] @id int, @name bigint, AS INSERT INTO Customer           (id,   Name   )     VALUES           (@id, @ Name )

Accepted Solutions (1)

Accepted Solutions (1)

former_member190719
Active Contributor
0 Kudos

Remove the REF in your declaration.

Answers (0)