Bug with Long Defintion of a View

oracle2000

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.

richardjm

Do you have single very long lines? I've seen issues where lines the overflowed onto the next could cause issues.

Eddie D

Duplicate of Forum post in the Source Control for Oracle forum, see HERE. A support call has been created.