Hi!
When running our web application the following message appears:
Failed to convert parameter value string to decimal. We believe that the problem might be with the sequence which generates the user_id. The user_id should
be the output after successful insert of record. The stored procedure works well from within the DB and Visual Studio. Our DB version: 11gR1 on Windows.
The web form has a button event with this c#-code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OracleClient;
using System.Text;
public partial class Test : System.Web.UI.Page
{
protected void button1_click(object sender, EventArgs e)
{
using (OracleConnection con = new OracleConnection("Data Source=DEV01;Persist Security Info=True;User ID=Test;Password=xxx;Unicode= ...
Go to the complete details ...