| concatenation problem [message #461233] |
Thu, 17 June 2010 03:32  |
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
|
Senior Member |
|
|
hi....
i have 3 fields on my form
field name datatype
1. adm_date date
2. class_session number
3. class_display char
i want that select year from data and it insert into class_session
and when i inserted into ADM_YEAR in class_session then
i want that i m selecting class_session-class_session+1
mean 2010-2011
and i write following code for this purpose..
:CLASS_INFO.CLASS_SESSION := TO_NUMBER(TO_CHAR(:PERSONAL_INFO.ADM_DATE, 'RRRR'));
:CLASS_INFO.SESSION_DISPLAY := TO_CHAR(:PERSONAL_INFO.ADM_DATE, 'RRRR')||'-' ||TO_CHAR(:PERSONAL_INFO.ADM_DATE, 'RRRR')+1;
my all code working correct then i exclude '-'
and this error is occurred when i button pressed...
FRM-40735: WBP TRIGGER RAISED UNHANDLED EXCEPTION ORA-06502
PLS HELP ME WHAT CAN I DO IT MY WORK...
|
|
|
|
| Re: concatenation problem [message #461239 is a reply to message #461233] |
Thu, 17 June 2010 04:03  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
"+ 1" is arithmetic. First TO_NUMBER those values, add 1, and - finally - TO_CHAR the result.
Something like
:display := to_char(:adm_date, 'rrrr') ||'-'|| to_char(to_number(to_char(:adm_date, 'rrrr')) + 1)
[Updated on: Thu, 17 June 2010 04:03] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
