Bug when view has a long definition/SQL

oracle2000 · January 21, 2015 10:03AM

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 · January 22, 2015 11:26AM

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 · January 23, 2015 4:41AM

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 · January 23, 2015 10:22AM

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

Bug when view has a long definition/SQL

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk