Oracle.DataAccess.Client.Oracl...

See more:

.NET

Oracle

VS2010

.NET4.5

VS2012

i have installed oracle 11g and oracle client for visual basic 2012(framework 4.5).
below is my code and error details .
Im new to oracle database.

Dim oradb As String = "Data Source=(DESCRIPTION=" _
         + "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))" _
         + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" _
         + "User Id=hr;Password=admin1234;"

       Dim conn As New OracleConnection()
       conn.ConnectionString = oradb
       conn.Open()
       Dim sql As String = "select roleid from userprofile where  username ='admin';" ' Visual Basic
       Dim cmd As New OracleCommand(sql, conn)
       cmd.CommandType = CommandType.Text
       Dim dr As OracleDataReader = cmd.ExecuteReader() ' Visual Basic
       dr.Read()
       Label1.Text = CStr(dr.Item("roleid")) ' retrieve by column name
       Label1.Text = dr.Item(0) ' retrieve the first column in the select list
       Label1.Text = dr.GetString(0) ' return a .NET data type
       Label1.Text = dr.GetOracleString(0) ' return an Oracle data type
       conn.Close()   ' Visual Basic
       conn.Dispose()

error :-


Oracle.DataAccess.Client.OracleException was unhandled
DataSource=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))
ErrorCode=-2147467259
HResult=-2147467259
Message=ORA-00911: invalid character
Number=911
Procedure=""
Source=Oracle Data Provider for .NET
StackTrace:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
at TestProject.Form1.Button1_Click(Object sender, EventArgs e) in C:\Users\Sidharth\AppData\Local\Temporary Projects\TestProject\Form1.vb:line 20


tnsnames.ora file contains

# Every line that begins with # is a comment line
#
# Create Oracle net service names, or aliases, for each database server
# you need to connect to.
#
# TNSNames.ora sample entry
#
# alias =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = orcl)
#    )
#  )
#
# You can modify the entry below for your own database.
# <data source alias> = Name to use in the connection string Data Source
# <hostname or IP> = name or IP of the database server machine
# <port> = database server machine port to use
# <database service name> = name of the database service on the server

OraDb=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )