473,652 Members | 3,173 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle Reports 6i on RDBMS 8i

DEVELOPERatHTS
4 New Member
Hi,
I am working on a requirement where I am returning a string to oracle reports which is more than 4000 characters long. As we know reports 6i has a limitation and it does not allow the diplay charaters to be more than 4000.
I am not sure how to approach this requirememnt.

This is what i have tried and have failed the purpose:
The string is being returned thr a PL/SQL function used as a select col in the query builder and has group by and order by.

1) I thought of using LONG but I cannot USE LONG since I am using it in a group by and Oracle does not permit that.
2) if I use CLOB as the function return variable - reports 6i gives inconsistent data types error as the data type reports 6i assigns to it is VARCHAR2(4000).

Is there a any other way by which I can display more than 4000 charatcers in a single field??

Please help,

Thanks,
DeveloperatHTS
Jun 26 '07 #1
1 1757
DEVELOPERatHTS
4 New Member
i did not get any answers, any suggestions people? No one from Reports backgnd??
Jun 29 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
8456
by: rawii | last post by:
I am running on a Sun box and am trying to install the perl tools to connect to Oracle. When I try to install the DBD::Oracle module, I get the following. Please help.. What does is mean and how can I fix it? 33% make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
3
5221
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no luck yet. Here is a short description of what I did so far: 1. I installed the jdk118_v3-glibc-2.1.3.tar in the /usr/local/ dir and made a symbolic link from /usr/local/java to this 2. I installed all the necessary groups and users (oracle,...
1
4590
by: cpchan | last post by:
If I want to upgrade the following system : (1) Oracle 8i RDBMS (2) Oracle Finance 11.5.2 to : (1) Oracle 9i RDBMS (2) Oracle Finance 11.5.8
4
19986
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
4
3909
by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3 (text base) as Front End" Now here is what I want to do " I want to migrate that database from Oracle for Unix to Oracle for Linux With retaining all the Forms, in other words all I want
125
15413
by: Rhino | last post by:
One of my friends, Scott, is a consultant who doesn't currently have newsgroup access so I am asking these questions for him. I'll be telling him how to monitor the answers via Google Newsgroup searches. Scott has heard a lot of hype about DB2 and Oracle and is trying to understand the pros and cons of each product. I'm quite familiar with DB2 but have never used Oracle so I can't make any meaningful comparisons for him. He does not have...
27
16486
by: Nasir | last post by:
Hi there, Is it posible to set the collation of SQL server 2005 like Oracle, which is that objects names and column names are case-insensitive, but data is sensitive;e.g: In Oracle: --create lower-case table and column name create table t1(c1 char(10)); --Mike with upper-case J
56
4931
by: Ashish Patankar | last post by:
I want to migrate my Oracle 10g database to Db2. I want some documentation for the comparision between these to databases. I also want to know which features of Oracle 10g are supported by Db2 and which are not supported.
1
2544
by: Chris Hohmann | last post by:
"Mujahid" <mujahid@iqura.netwrote in message news:OuhAYozFAHA.271@cppssbbsa04... me Oracle Database Utilities (Data Pump/SQL Loader) http://otn.oracle.com/products/database/utilities/index.html Oracle OLAP http://otn.oracle.com/products/bi/olap/olap.html
0
8367
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8279
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8703
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8467
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5619
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4145
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4291
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2703
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1914
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.