RE: SQL Function

I think you may be missing a carriage return at the end. Go to the last line of your code hit the delete key then press enter then save and compile.
Hopefully this will correct it.

Rick

> -----Original Message-----
> From: Uma Sankara_Sivadanam [SMTP:UmaSankara_Sivadanam_at_satyam.com]
> Sent: Friday, July 14, 2000 8:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL Function
>
> Hi All,
>
> 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?
>
> Thanx
> Uma Shankar
>
>
>
>
> ----------
> From: blair_at_pjm.com[SMTP:blair_at_pjm.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, July 14, 2000 6:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Snapshot too old
>
> 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.
>
> 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.
>
> tia,
>
> ..tom
>
>
>
>
> --
> Author:
> INET: blair_at_pjm.com
>
> 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).
Received on Fri Jul 14 2000 - 07:26:12 CDT