|
-
July 11th, 2012, 02:41 AM
#1
I need help for an insert
Hi,
I'm traying to run a function on server which is supposed to insert a record in a table. I'm having problems with this function
Public Function InsertSirPlj(ByVal xCOD As Decimal, ByVal xDEN As String, ByVal xABR As String, ByVal xSTARE As String, ByVal xDATA As DateTime, ByVal xTLG As String) As Boolean
Dim sqlInsert = "insert into sirplj(COD , DEN , ABR , 'D', DATA , TELEGRAMA ) VALUES ( cod, den, abr, data, telegrama)"
On Error GoTo xError
Oraclecon.Open()
Dim cmdInsert = New OracleCommand()
cmdInsert.CommandText = sqlInsert
cmdInsert.Connection = Oraclecon
Dim pCOD = New OracleParameter()
pCOD.DbType = DbType.Double
pCOD.Value = xCOD
pCOD.ParameterName = "pCOD"
..... the other parameters
cmdInsert.Parameters.Add(pCOD)
........
cmdInsert.Parameters.Add(pTLG)
cmdInsert.ExecuteNonQuery()
cmdInsert.Dispose()
.......
It gives me this:
System.InvalidCastException: Conversion from string "ORA-00972: identifier is too lon" to type 'Boolean' is not valid. System.FormatException: Input string was not in a correct format.
I'm new in VB and I really don't know what to do. Can anyone help me?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|