Re: Can a do a "DESCRIBE <tablename>" from OCI?

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0411290335.3f2331a4_at_posting.google.com>...
> ramon_at_conexus.net (Ramon F Herrera) wrote in message news:<c9bc36ff.0411282342.e6a8b6a_at_posting.google.com>...
> > I am writing a program whose purpose is to create .dat
> > files which are going to be used later by SQL*Loader.
> >
> > I would like my program to find out in real time whether
> > any of the fields that are going to be inserted in the
> > table are too wide.
> >
> > Therefore, I would like to have my OCI program connect to
> > the database an perform some sort of "DESC tablename"
> > command or equivalent. Perhaps I should perform a
> > SELECT FROM USER_TABLES?
> >
>
> Perhaps you should... coupled with a select from user_tab_columns.
> DESC[RIBE] is a SQL*Plus command.
>
> Regards
> /Rauf

Actually come to think of it OCI has an OCIDescribeAny call which is used with the OCIAttrGet call to get object information.

HTH -- Mark D Powell -- Received on Mon Nov 29 2004 - 17:04:10 CST