2 Replies Latest reply on Mar 17, 2015 3:47 PM by thatJeffSmith-Oracle

    Run SQL stored procedure from Oracle SQL Developer

    2905651
    2905651 Mar 17, 2015 2:35 PM

      Hello All,

       

      I've installed Oracle SQL Developer on a Mac to access the SQL server instance. I need to run the below stored procedure from Oracle SQL Developer. Can you guys give me a hand on this? Here is my Stored procedure:

       

        DECLARE @Job CHAR(20)

        DECLARE @ID INT

        EXEC Job.dbo.GetNewNumber '9256', 'Test Job 4', 'Auto Process', @JobNumber=@Job OUT, @recID = @ID OUT, @Display='A';

        SELECT @Job, @ID

       

      Thanks