getting table details using oracle

[mmary]

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

[GaryMazzone]

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

[mmary]

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


with thanks and regards
mmary

[GaryMazzone]

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

[drattansingh]

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

Jen