PL/SQL: cheking for the OVERFLOW of an Variable

From: baka <mesundara_at_hotmail.com>
Date: 27 Jun 2005 05:25:01 -0700
Message-ID: <1119875101.663810.125890@g47g2000cwa.googlegroups.com>

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 Received on Mon Jun 27 2005 - 07:25:01 CDT