Home » Developer & Programmer » Forms » form probem ora-06502 (form 6i windos xp)
form probem ora-06502 [message #281601] Sun, 18 November 2007 11:41 Go to next message
hemu
Messages: 16
Registered: May 2007
Junior Member
declare
s varchar2(20);
x varchar2(3);
y varchar2(3);
z varchar2(3);
o number(3);
p number(3);
n number(3);
begin
s:=get_item_property('t1',background_color);
select length(s) into n from dual;
select instr(s,'g') into o from dual;
select instr(s,'b') into p from dual;
break;
o:=o-1;
select substr(s,2,o) into x from dual;
message(x);
/*break;
select substr(s,o+1,p-1) into y from dual;
break;
select substr(s,p+1) into z from dual;

message(y);
message(z);*/
message(' ');
end;
in run time there is proble error orrcured ora-o6502
thax in advance
Re: form probem ora-06502 [message #281610 is a reply to message #281601] Sun, 18 November 2007 13:19 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle

ORA-06502 PL/SQL: numeric or value error string

Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).

Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.


A hint: you've declared variables that are too small in size to accept values you'd like to store into them. For example, test it with the RED background (r255g0b0) and see what happens. Do NOT run it through Forms, use paper and pencil instead.
Previous Topic: pre-form
Next Topic: Time Operations
Goto Forum:
  


Current Time: Sun Dec 04 02:22:27 CST 2016

Total time taken to generate the page: 0.04680 seconds