Re: Using DBMS_OUTPUT to output columns?

To jump in from the other packages side, if you are using ODBC, there are api's that will tell you the number of columns. In fact, retrieval is based on column level binding, not row level binding.

Basically PRO*C and OCI do the same thing. (All right, not the same way, but the same functionality.)

For what you want, you probably want to do something like:

 printvar := rpad(cursor.field1,32,32)||rpad(cursor.field2,32,32) ||.......
 dbms_output.putline(printvar);

Since you are using dbms_output, to find out how many columns there are would be a query like:

select count(*) into :colcount from user_tab_columens where table_name='FRED';

In article <016e2c0c.9fe278d5_at_usw-ex0106-047.remarq.com>,   phersh <philhershNOphSPAM_at_hotmail.com.invalid> wrote:
> I looked in the trace file. Can anyone point me to the info that
> decodes what the control and seperator characters are?
>
> Thanks,
> Phil
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.