Re: [Firebird-net-provider] Problem with stored proc and blob

2006-06-22 Thread Le roy Arnaud
> I have an error : > arithmetic exception, numeric overflow, or string truncation > > because buf is empty but not null ! > > It is normal ? > Sorry it's nothing , it's me :) All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number o

Re: [Firebird-net-provider] Problem with stored proc and blob

2006-06-22 Thread Le roy Arnaud
> Is the SP parametr sub_type text? Ok it was the problem thanks ! An other little question in the sp one paremeter is BLOB SUB_TYPE 0 SEGMENT SIZE 80. and when i add a parameter : cmd.Parameters.Add("@PropertyValuesBinary", FbDbType.Binary,buf.Length).Value = buf I have an error : arithmeti

Re: [Firebird-net-provider] Problem with stored proc and blob parameter

2006-06-21 Thread Jiri Cincura
Is the SP parametr sub_type text? -- Jiri Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support.

[Firebird-net-provider] Problem with stored proc and blob parameter

2006-06-21 Thread Le roy Arnaud
hello in this exemple i have this error message "error to convert string to byte[]" conn = new FbConnection(_fbConnectionString); FbCommand cmd = new FbCommand("PROFILES_SETPROPERTIES", conn); conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(CreateInputParam("@Applic