Using define_column when number of columns are varying

From: K.T.RAJA <sudip.roy_at_in.bosch.com>
Date: 12 Nov 1999 03:43:48 GMT
Message-ID: <01bf2cc0$abe94e00$170394ad_at_qcs_01_95w.ban.india.bosch.com>



Hi,

[Quoted]    I am writing a package using DBMS_SQL.I build a select statement using the table name and the Keys supplied by the user.I select the columns from cols and build the select statement.So my select statement has varying number of columns.Lets assume that the data Types of these columns are CHAR,NUMBER and DATE.So how do i Use the DEFINE_COLUMN procedure.I cant declare variables offhand.

                Please i request suggestions as early as possible.Please
write to me at Madhushekhar_at_bosch.com.
                Thanks in advance.
                                                                           
                        Regards Madhu Shekar
                                                                           
                        Bangalore
Received on Fri Nov 12 1999 - 04:43:48 CET

Original text of this message