Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

do i need a terminator(or something else) between dynamic sql statements

working with Oracle Linked server in SSMS 2008R2

do i need a terminator(or something else)  between  OPENQUERY/dynamic sql statements

I have this line of code

TRUNCATE TABLE [dbo].[XREF_HEADER_DETAIL_ORACLE_EXTRACT_2019_STAGING]
begin try

DECLARE @StartDate AS VARCHAR(10) = '07-JAN-19';
DECLARE @EndDate AS VARCHAR(10) = convert(varchar, getdate(), 101);
DECLARE @Statement NVARCHAR(MAX) = N'
    SELECT *
    FROM OPENQUERY(
        XREF_PROD,
        ''SELECT


etcx......  code


EXECUTE sys.sp_executesql @Statement;



end try
BEGIN CATCH  
   select
   ERROR_NUMBER() AS ErrorNumber,
		ERROR_STATE() AS ErrorState,
		ERROR_SEVERITY() AS ErrorSeverity,
		ERROR_PROCEDURE() AS ErrorProcedure,
		ERROR_LINE() AS ErrorLine,
		ERROR_MESSAGE() AS ErrorMessage;
END CATCH



--- do i need additional code here between statements/dynamic sql statements  ?

--- next dynamic sql statement  

TRUNCATE TABLE [dbo].[ORACLE_CUST]


    SELECT *
    FROM OPENQUERY(
        XREF_PROD,
        ''SELECT reportsTor,


code etcccc...

Open in new window



Thanks
fordraiders
Avatar of Qlemo
Qlemo
Flag of Germany image

Your code is not complete enough to really tell what you are after, but no.
The second block does not contain dynamic SQL, btw.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

Thanks