Hi,We have created a Stored procedure which insert the valu form notes to sybase using DECS.
we are getting following error msg
1st] Parameter name not supplied: @fincl_year, Connector ‘odbc2’, Method -Call-
OR
2nd]05/20/2009 06:52:03 PM Monitor failure – Field type mismatch: ‘fincl_year’ Source Connector field is type Text
Connector ‘odbc2’
We have tried to ways
1st) we created a connection with procedure and
mapped the fields with notes form in activity and got the First error msg.
then we have gone through the DECs document and find out we should not use procedure directly and tried mapping with table and use stored procedure in event options
2nd) we created a connection with table and mapped the fields accordingly, there after we pasted the Stored procedure name in the Event option. and got the 2dn error msg.
My application is Web-based, while mapping the notes field with the table without using Stroed procdure everything is working fine. but when we use stored procdure the problem occurs.
And while DCES log generates error data in notes is not saved as well.
Server R8.0.1 on RHEL 5
Any suggestion in this regard will great Help
Thanx in adv.