Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: solution: returning the contents of dbms_output after running a sp in vb .net
ok, i found a mistake:
cmdShow.Parameters.Add("buffer", OracleDbType.VarChar).Direction =
ParameterDirection.Output
should become
cmdShow.Parameters.Add("buffer", OracleDbType.Long).Direction =
ParameterDirection.Output
I didnt realise the oracle data type of Long is a big string as opposed to the vb net type wihich is a big integer, and I was getting overflows Received on Tue Oct 31 2006 - 11:44:58 CST