0

I have pl/sql statement something like mentioned below, which executes successfully in oracle sql developer but same when am trying to execute through control M database task (execution type :- Embedded Query) am getting error "Invalid SQL statements"

SQL statements :-

TRUNCATE TABLE TEST; COMMIT;

EXECUTE USP_LOADTESTTables; COMMIT;

Mahesh
  • 198
  • 2
  • 16

1 Answers1

1

create a query file named plsql_query.ql then use it to execute from controlM as command line job. Sqlcmd -E -server\instance_name -Q "EXEC plsql_query.ql"

dhilip77
  • 11
  • 1
  • Welcome to SO! Please edit your answer and explain why and how your solution works. – B--rian Aug 28 '19 at 13:04
  • This is commandline script for running sqlcmd like plsql, mentioned script has -E for trusted entity or server and -Q is sql script as a text file. – dhilip77 Aug 28 '19 at 13:38