Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I output a long datatype?

Re: How do I output a long datatype?

From: <wweng_at_ei.org>
Date: 21 Jan 1999 16:12:52 GMT
Message-ID: <787jm4$8hj$1@eipipeline.ei.org>


John Koo <johnkoo_at_i-wave.net> wrote:
>>wweng_at_ei.org wrote:
>>>
>>> How do I output a LONG datatype into standard output or a file?
>>> I can't use DBMS_OUTPUT package, since all its functions don't take LONG datatype as argument.
>>>
>>> Please help
>>> Thanks
>>>
>>> wei

>>You may write a ProC program or extract data thru' OCI interface.
>>A third party database tool can also help in here. Or you may use
>>the dbms packages provided by Oracle but it depends on your Oracle
>>version.

>>John Koo

Thanks for the reply.
I have one more question on LONG type.
I used to use oraperl to interface oracle with my perl script. But somehow, the extract from LONG datatype doesn't return me anything. Is there anything wrong with oraperl dealing with LONG datatype? Is there any other perl-oracle tool I can use?

wei Received on Thu Jan 21 1999 - 10:12:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US