getting table details using oracle

hi to all,
i am using the following code for getting the table details.But i giving the error "ORA-00900: invalid SQL statement". the code is


oledbcon = new OleDbConnection("Provider=OraOLEDB.Oracle;User Id=" + strusername + ";Password=" + strpassword + "");
oledbcon.Open();

oledbcmd = new OleDbCommand(query,oledbcon);
oledbreader = oledbcmd.ExecuteReader();
while (oledbreader.Read())
{
MessageBox.Show(oledbreader[0].ToString());
}

oledbreader.Close();
oledbcon.Close();

Plz somebody help me to solve the problem.

thank u
with thanks and regards
mmary

See post 5 in thread: http://www.vbforums.com/showthread.php?t=461669

thank u for ur kind help. its really working.thank u very much.


with thanks and regards
mmary

If this resolves your issue could you mark the thread as resolved using the thread tools menu.

Hey, could you post what the error was and the solution?

Jen