Re[2]: Visual Basic and Oracle -Reply -Reply -Reply

From: David Godfrey <David_Godfrey_at_CONAK1CC_at_SMTP.CONTINUUM.CO.NZ>
Date: Mon, 4 Mar 1996 16:48:56 NZT
Message-Id: <9603040400.AA12616@alice.jcc.com>

Hello,

Just one word of warning for this approach - previously I've done this, and the maximum concatenated string length was 255 characters. The output just didn't appear after that was exceeded per row.

The way we got round it was, concatenate a few fields you know won't exceed 255 chars, then have an unusal character you know won't appear in the data, then concatenate the next few fields, then the same char etc.

You then have to be able to edit this output, via word, or if too large, sed, and find and replace the special character with whatever.

This is painful, but it worked.

ttfn

David Godfrey

dgodfrey_at_continuum.co.nz

______________________________ Reply Separator _________________________________

Subject: Re: Visual Basic and Oracle -Reply -Reply -Reply Author: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU> at INTERNET Date: 04/03/1996 4:37 PM

Lewis Payton wrote:
>
> ---------------------- Information from the mail header

---

> Sender: "ORACLE database mailing list." <ORACLE-L_at_SBCCVM.BITNET>
> Poster: Lewis Payton <PAYTOLN_at_SMTPGATE.DUC.AUBURN.EDU>
> Subject: Re: Visual Basic and Oracle -Reply -Reply -Reply
>

---

>
> Hi,
>
> Thanks for the reply.
>
> We are using Oracle 6.0 and Forms 3 because it feeds a central Navy
> system that uses Oracle 6.0.
>
> All I want to do is import the data as a flat file into Lotus Approach 96
> which supposedly reads Oracle files .... not..... without buying another
> programs from Oracle first though..
>

Approach does not read oracle datafiles to the best of my knowledge, it does allow you to connect to an Oracle datasource using ODBC thru SQL*Net.

> I would be happy if someone could tell me how to just Export our ORacle
> 6 tables as a Flat File, either a DBF format or even ASCII
> Lewis

You can simpley create a SQL statement that selects the data you want and write to an ASCII text file using SQL*Plus
ie

SELECT <column_name> || ';' || <column_name> FROM <table_name>;

Hope this is helpful

Wayne

GO Gators!!! Received on Sun Mar 03 1996 - 23:00:44 CST