Re: PL/SQL: cheking for the OVERFLOW of an Variable

baka wrote:
> Dear Sir/Madam
> In PL/SQL how can I Find the maximum length of an variable inside the
> PL/SQL block
>
> here is my problem (Image only)
>
> CREATE OR REPLACE PROCEDURE test1(strin varchar2) is
> DECLARE
> tstr2 abctablel.col1%TYPE;
> ......
>
> Begin
>
> LOOP
> tstr2 := substr(strin,instr(strin, '\') + 1);
> IF LENGTH(tstr2)<=LENGTH(abctablel.col1) THEN
> VVVVVVVVVVVVVVVVVV??????????
> do something
> .......
> .......
> printme(' Thanks for the proper input');
>
> exit;
> ELSE
> printme('You have some serious Problem ,chek the size');
> exit;
> END IF;
> END LOOP;
>
> END;
>
> How can i Compare the [VVVVVVVVVVVVVVVVVV?????????? ] Portion
>
>
> Thank you in ADVANCE

select data_length
from user_tab_columns
where table_name = 'ABCTABLEl'
and column_name = 'COL1';

Regards
/Rauf Received on Mon Jun 27 2005 - 10:49:10 CDT