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 -> Limiting size of function return value

Limiting size of function return value

From: <pat_800_at_my-dejanews.com>
Date: Tue, 06 Apr 1999 21:52:10 GMT
Message-ID: <7edvm7$lin$1@nnrp1.dejanews.com>


Would anyone perhaps know how I might limit the size of a VARCHAR2 return value for a PL/SQL function called within a SQL statement? I have constrained the length of the internal function variable that is returned, yet any tool that I for querying (SQL*Plus, TOAD, SAS) always creates a field of the maximum allowable size for its text data type. This results in fields of 200 - 2000 bytes for a 20-byte-max value. The value is not padded to the right or left, so trimming is useless. Oracle just doesn't seem to know how large the value will be, so it allocates the max.

Any thoughts on how I might limit this behavior would be greatly appreciated.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 06 1999 - 16:52:10 CDT

Original text of this message

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