Re: SQL Function

From: William Beilstein <BeilstWH_at_obg.com>
Date: Fri, 14 Jul 2000 10:06:18 -0400
Message-Id: <10558.112067@fatcity.com>

Don't worry about the turncate message. Your function will work fine.=20

>>> Venugopal V V S <venug_at_cse.iitb.ernet.in> 07/14/00 09:41AM >>> Hi,
Just follow the acompanying messages with this error. "show error" can help and also try
select * from user_errors;
Rgds..

---

Venu Gopal VVS.
Software Engineer.
Project SMARS.
Dept. of Comp. Sc. & Engg.
IIT Bombay, Powai
Mumbai, INDIA, 4000076 =09
Lab.Phone.5782545 X 8913
Direct Ph. 5768703
Tansa Room# 331 Ph.5612

 	=09
		URL         http://venug.8m.com/index.htm=20
                Resume      http://venug.8m.com/resume.htm=20
___________________________________________________________________________=

__

On Fri, 14 Jul 2000, Uma Sankara_Sivadanam wrote:

> Hi All,

>=20

> When i create a new SQL function, while compiling it it is giving a = message

> telling input truncated to 1 character.what is this error?Any idea?

>=20

> Thanx
> Uma Shankar

>=20
>=20
>=20
>=20

> > ----------
> > From: 	blair_at_pjm.com[SMTP:blair_at_pjm.com]=20
> > Reply To: 	ORACLE-L_at_fatcity.com=20
> > Sent: 	Friday, July 14, 2000 6:20 AM
> > To: 	Multiple recipients of list ORACLE-L
> > Subject: 	Snapshot too old
> >=20
> > We are having trouble exporting a database with several large,
> > insert-active
> > tables.  Exporting these tables causes a 1555 "Snapshot too old" =

error.
> > The
> > error message says use larger rollback segments. I doubled the size = of

> > our
> > rollback segs but I don't want to make them all bigger just for one
> > occasional
> > export.
> >=20
> > Is there a way to create a and use a very large rollback segment just =

for

> > the
> > export?  How would you approach solving this problem - this is a
> > production
> > database and taking it off-line is probably not possible.
> >=20
> > tia,
> >=20
> > ..tom
> >=20
> >=20
> >=20
> >=20
> > --=20
> > Author:=20
> >   INET: blair_at_pjm.com=20
> >=20
> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California        -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >=20

>=20

--=20
Author: Venugopal V V S
  INET: venug_at_cse.iitb.ernet.in=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Fri Jul 14 2000 - 09:06:18 CDT