ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oleksandr Diachenko" <>
Subject Review Request 17316: During Oracle schema upgrade ORA-06502: PL/SQL: numeric or value error: raw variable length too long
Date Fri, 24 Jan 2014 16:07:51 GMT

This is an automatically generated e-mail. To reply, visit:

Review request for Ambari, Myroslav Papirkovskyy and Sid Wagle.

Repository: ambari


Changes was made in script Ambari-DDL-Oracle-UPGRADE.sql:
- Update statement that fills table column "stage.cluster_host_info" was changed to deal with
long commands.
- Analytical function "ROW_NUMBER" was added to handle duplicates.
- New function was added: "compress_cluster_host_info_pkg.substr_blob" - it is similar to
"dbms_lob.substr", but has no limitation in a maximum buffer size of 2000 bytes.
- Fixed using of correct type nested_vachar2_tbl_type.


  ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Oracle-UPGRADE.sql 53b2b7a 




Oleksandr Diachenko

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message