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

Home -> Community -> Usenet -> c.d.o.misc -> Re: URGENT HELP REQUIRED - long data types not being returned correctly

Re: URGENT HELP REQUIRED - long data types not being returned correctly

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 16 Jun 2004 03:57:47 GMT
Message-ID: <%yPzc.41261$eu.19420@attbi_s02>

"Edwinah63" <edwinah_at_customercare.com.au> wrote in message news:d714e824.0406151952.3a2287c2_at_posting.google.com...
> Hi everyone,
>
> i am in desperate need here. we have recently moved to Oracle 9i -
> all is well except crystal reports - in certain cases!
>
> i have report that pulls across text fields per medical case from a
> stored procedure in oracle.
>
> typical fields are: patient number (varchar 10), patient name
> varchar(60), age (number), address (varchar 100), summary date
> (datetime),
> medical summary (long).
>
> stored proc parameters would be to print any medical summary written
> between date 1 and date 2.
>
> the report is grouped on patient number, and forces a new page on
> change of patient number after the group footer.
>
> my problem is
>
> the entire report itself might be 100 + pages, BUT, if individual
> patient reports exceed 3 pages, that patient's report is inexplicably
> cut off after the 3rd page. any patient report under 3 pages
> prints/previews fine.
>
> what we have
> server: Oracle 9i/Win 2k
>
> client: CR Oracle 8 v3.6 (Merant Inc) drivers for from Business
> Objects, Net 8 client (version 8.17), vb6 client app, win2k. crystal
> reports built using CR 8.
>
> the vb6 app calls the Crystal report which in turn calls the oracle
> stored proc via the merant drivers/Net 8.
>
> i have checked the stored proc - all records for all patients are
> returning completely. i have checked through ms access and the long
> field is returning correctly so i know that the microsoft ODBC driver
> for oracle works fine. the vb6 app using ADO returns the long field
> data correctly.
>
> i have tried CR versions 8 ~ 10 but all exhibit the same problem.
>
> in version 10 i have tried changing the data sources (RDO, ADO, Oracle
> driver etc etc) all show that long data fields over a certain lenght
> are cut off.
>
> i am convinced this is a packet or buffering issue. has anyone else
> observed this?
>
> Does anyone have any idea?
>
> what else can i check?
>
> i am absolutely in need here as we run these medical reports 2 x daily
> for patients.
>
> regards
>
> Edwinah63

Let me guess the long column is only returning 32k. pl/sql long type is limited to 32k.
Jim Received on Tue Jun 15 2004 - 22:57:47 CDT

Original text of this message

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