Skip to Main Content
Merative Ideas Portal

Shape the future of Merative!

We invite you to shape the future of Merative, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the Merative team to refine your idea

Help Merative prioritize your ideas and requests

The Merative team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at Merative works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at Merative, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Merative External Privacy Statement: https://www.merative.com/privacy

Status Not under consideration
Created by Sigitas Jakucionis
Created on Jul 17, 2018

UpgradeHelper: Cannot execute SQL's with more than 2499 characters with SQLPlus

SQL statements generated by UpgradeHelper are skipped during execution because the statement was longer than SQLPlus allows (<2499 chars):
"Error: SP2-0027: Input is too long (> 2499 characters) - line ignored"

Requesting to update UpgradeHelper and generate long statements with inserting a carriage return at a point where the first line does not exceed 2499 characters. Each line of SQL command cannot exceed 2499 characters, so insert as many carriage returns as needed.

Based on TS001005407.

Customer Name Minnesota
  • Attach files
  • Guest
    Reply
    |
    Dec 3, 2018

    Hi Sigis,

    We have evaluated your request and have determined that it cannot be implemented at this time.

    We tested with Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and here the SQL statements specified above could be run successfully using the SQL Plus delivered with that version.
    Oracle recognized this as an issue based on feedback and have addressed it in a later version. This can be seen in the new limits they have specified for the Oracle 12.2 version.
    https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SQL-Plus-limits.html#GUID-93CA1BD6-888F-40FD-B57F-0B782C96854F

    Your request may be resubmitted for consideration after 12 months from the date of decline.

    Thank you,
    Shane McFadden, Cúram SPM Product Management team

  • Guest
    Reply
    |
    Jul 25, 2018

    Hi Sigis,

    Thank you for your enhancement request.
    We require some further analysis to determine whether or not this enhancement can be considered in a future release.
    I will provide another response when our investigation is complete.

    Thank you,
    Shane McFadden, Cúram SPM Product Management team