7 Replies Latest reply: Feb 10, 2014 2:02 PM by user3191291 RSS

How do I call DBMS_SCHEDULER Jobs from CommandText in C#?

user3191291 Newbie
Currently Being Moderated

It is OK when I run the command, exec sys.DBMS_SCHEDULER.run_JOB('SYS.My_Job'); on sql *Plus.

 

An error, "PLS-00103: Encountered the symbol \"SYS\" when expecting one of the following:\n\n,,." was received when I tried to call DBMS_SCHEDULER jobs using DBMS_SCHEDULER.run_job from CommandText in C# as the following.

 

Oracle.DataAccess.Client.OracleCommand cmd = conn.CreateCommand();

cmd.CommandText = "exec sys.DBMS_SCHEDULER.run_job('SYS','My_Job');";

cmd.CommandType = System.Data.CommandType.StoredProcedure;

cmd.Connection = conn;

 

I would appreciate if you can help me. Thanks.

 

cyh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points