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

Bug with Long Defintion of a View

I have view that has a very long Definition/SQL

SELECT * FROM all_views WHERE view_name = 'V_FT_CONTRIBUTION'
Gives me a TEXT_LENGTH of 80001.

"Schema Compare for Oracle" seem to cut the view-definition at the end before checking it into TFS.
Leaving me with an incomplete and invalid view that does not compile in PROD.
oracle2000
0

Comments

2 comments

  • richardjm
    Do you have single very long lines? I've seen issues where lines the overflowed onto the next could cause issues.
    richardjm
    0
  • Eddie D
    Duplicate of Forum post in the Source Control for Oracle forum, see HERE. A support call has been created.
    Eddie D
    0

Add comment

Please sign in to leave a comment.