1310331 - Stored Oracle procedure returning a number causes the job to fail when assigned to decimal

 A stored procedure call assignes a return value of data type number to a decimal in Data Services results in job failure

• $GV_hello_world as decimal(28,7)
  • 3428  960       SYS-170101      2/20/2009 11:02:56 AM  System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\\Program Files\\Business Objects\\BusinessObjects
  • 3428  960       SYS-170101      2/20/2009 11:02:56 AM  001B:0081B79C, Exec_frame::set_xvar()+0188 byte(s), x:\\src\\eval\\frame.cpp, line 0340+0004 byte(s)
  • 3428  960       SYS-170101      2/20/2009 11:02:56 AM  001B:00E95E6D, XStep_assn::execute()+0077 byte(s), x:\\src\\core\\step.cpp, line 0072
• $GV_hello_world as decimal(8,2)
  • 1672  2060     RUN-050802      2/20/2009 11:04:23 AM  Cannot convert data <> into type <DECIMAL>. Context: Column <>.
• $GV_hello_world  as int
  • 4340  4336     SYS-170101      2/20/2009 9:30:01 AM    System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\\Program Files\\Business Objects\\BusinessObjects
  • 4340  4336     SYS-170101      2/20/2009 9:30:01 AM    001B:0081F344, Convert()+0932 byte(s), x:\\src\\eval\\calc.cpp, line 0302+0005 byte(s)
  • 4340  4336     SYS-170101      2/20/2009 9:30:01 AM    001B:007E5690, XVal_cast::compute()+0272 byte(s), x:\\src\\core\\compute.cpp, line 1664

oracle stored procedure, data type number, Cannot convert data, Convert(), XVal_cast  , KBA , EIM , Enterprise information management solutions , Bug Filed