Bug when view has a long definition/SQL

oracle2000oracle2000 Posts: 13
edited January 23, 2015 10:22AM in Source Control for Oracle
I have a view that is has a very long definition/(SQL).

SELECT text_length FROM all_views WHERE view_name = 'V_FT_CONTRIBUTION'
Returns 80001

But it seem like "Source Control for Oracle" is cutting the text of the view at the end before checking the source into TFS.
Thus giving me an incomplete an invalid view in TFS. Which never will compile.

Comments

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Thank you for your forum post.

    What version of Source Control for Oracle are you using?

    What version of TFS is being used?

    What version of Oracle is the linked database using?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • These are my version:

    Oracle: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
    Source Control For Oracle: Version: 2.0.7.1037
    TFS: 11.0.61030.0
  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Thank you for your reply.

    I do not have a view on my test system any where close to the text length in excess of 80,000 characters.

    I have generated a support ticket which can be viewed HERE.

    Can you please update the call with the DDL of the view in question or send an email to support@red-gate.com (and include 'Support Call #35750' in the title field of the email) which includes the DDL of this view?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.