DESCRIBE is a SQLPLUS command, not a SQL statement. I'm looking at the Oracle SQL Reference (8.1.7) and DESCRIBE isn't listed.
An alternative that works for me is select * from sys.user_tab_columns where table_name = <table> order by column_id; HTH, Dave On May 13, Jimmy Jauhal scribed: > Hi All, > > I am trying to execute a DESCRIBE table statement from my perl script that > connects to an oracle DB. For some reason the execute fails saying that > "describe table" is not a valid SQL statement. When I try SELECT > statements they work fine and fetch data properly. > > DBI version 1.30 > DBD::Oracle version 1.12 > > Any help would be appreciated. > Thanks, > -Jimmy > >
