Bug when view has a long definition/SQL

oracle2000

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.

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

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

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