Skip to Content
0
Former Member
Sep 23, 2014 at 04:29 PM

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

390 Views

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 )