Options
Bug when view has a long definition/SQL
oracle2000
Posts: 13
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.
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com