on 09-23-2014 5:29 PM
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 )
Remove the REF in your declaration.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.