Re: identifying variable declaration within PL/SQL

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 31 Mar 1999 15:27:11 GMT
Message-ID: <37023F92.B23FFF59_at_sympatico.ca>

Answer inline

Ingo Peters wrote:

 Not a bad thought. I certainly have never used the VSIZE function. However, I found 2 problems with this:
 

PLS-00204: function or pseudo-column 'VSIZE' may be used inside a SQL statement only

This is easily solved within PL/SQL with :select vsize(customer_rec.line_storage)
   into v_vsize
   from dual;
if length(line_of_text) > v_vsize

 

This means that I can't use it in straight old PL/SQL.
Furthermore, the function only returns the actual number of bytes used in storage -- it does not return the declared length.

But this might be more difficult. I think you will need to go to the data dictionnary for this.... Bummer.

 

Ingo
 

Marc Mazerolle wrote:

Would this work ?if length(line_of_text) > vsize(customer_rec.line_storage)

LGS in Ottawa ? Why does your mail say "Organization : Bell Solutions" ?

Regards,

Marc Mazerolle
InforMaze Inc. Received on Wed Mar 31 1999 - 17:27:11 CEST