How can we help you today? How can we help you today?

Bug when view has a long definition/SQL

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.
oracle2000
0

Comments

3 comments

Sort by
  • Eddie D
    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 D
    0
  • oracle2000
    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
    oracle2000
    0
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.