| ORA-06502 [message #502324] |
Tue, 05 April 2011 19:45  |
 |
ekwas
Messages: 5
Registered: April 2011
Location: manila
|
Junior Member |
|
|
is this syntax is correct?
declare
vnumber1 number(5,2);
vnumber2 number(5,2);
vnumber3 number(5,2);
vanswer number(5,2);
vanswer2 number (5,2);
begin
vnumber1 := :md.test5;
vnumber2 := :md.test6;
vnumber3 := :md.test7;
vanswer := (:md.test5 + :md.test6 + :md.test7)/3;
if vanswer >=76 then
vanswer2 := 'PASSED';
:md.test8 := vanswer || ' ' || vanswer2;
elsif vanswer =75 then
vanswer2 := 'PASSING';
:md.test8 := vanswer || ' ' || vanswer2;
elsif vanswer <=74 then
vanswer2 := 'FAILED';
:md.test8 := vanswer || ' ' || vanswer2;
end if;
end;
|
|
|
|
| Re: ORA-06502 [message #502352 is a reply to message #502324] |
Wed, 06 April 2011 01:20  |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Before your next question, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
In the end, when you find the solution, post it for the future that will make the same error:
vanswer2 number (5,2);
vanswer2 := 'PASSED';
Regards
Michel
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
