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

Home -> Community -> Usenet -> c.d.o.server -> How to set the size of string returned by PL/SQL functions?

How to set the size of string returned by PL/SQL functions?

From: John Heitmuller. <john.heitmuller_at_jrfcorp.net>
Date: Thu, 04 Oct 2007 07:23:11 -0700
Message-ID: <1191507791.909137.298080@o80g2000hse.googlegroups.com>


Hi, I have created a PL/SQL function that return a VarChar2. I then call that function in a view to provide one of the columns in the view. The string that the function returns can never be longer than 15 character. When I run a desc on the view it shows function column as VarChar(4000). Can I change I define a size for the VarChar2 returned by the function?

I've looked in the docs and I must just not be thinking about it in the correct context.

Thanks,
John Received on Thu Oct 04 2007 - 09:23:11 CDT

Original text of this message

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