Hi

We exported oracle database from 19c and imported to Oracle 11.2 COMPATIBLE parameter using Oracle 19c binaries.

The pre, sch script works, but the bcp scripts not getting applied to the...

Hi Ed

Thanks for the reply

I use the same suggested line break

Please find attached script I am using it.

Hi Ed

Even running it directly on MSSM tool, it gives the error.

Please help on this issue.

CREATE VIEW [PGCPS_CUSTOM].[EGB_CC_SEQ_STANDARDS_VW]

AS

SELECT [ID], [CC_SEQ_ID], [STANDARD_ID], [SEQ], CAST([CONTENT] AS varchar(2000)) AS [CONTENT], [INSTRUCTION_DAYS], [START_DAY_NUM] FROM...

Thanks Ed

Adding left and right variable and print shows the full string info

Saved that script as a.sql and I would like to run it using sqlcmd by passing it

sqlcmd -S...

Thanks and appreciate your help Scott.

Added the drop command before the CREATE view command..

Even though the view_code variable declared as MAX it stores only 8000 characters...

Some view commands doesn't include...

• This reply was modified 8 months ago by  rpalani65sql.

Thank you very much Scott and Ed.

First I trying to get the output and change to sys objects to see the difference.

Some of the tables are having more than 200...