I've recently switched my main development environment over to a Mac, and have been absolutely elated to seemingly be able to use Oracle SQL Developer to connect remotely to SQL Server instances. It's been some time since this question was asked/answered. There is obviously some text processing before sending commands to SQL Server. But not only does exec not work, but Execute does not work either or omitting execute/exec (valid for a single-line SP query) shows a syntax error. But, you don't use parentheses when calling an SP in T-SQL. Print out the data from the stored procedure.Īlso, theFurryOne, Begin and End are part of the T-SQL language of MS SQL Server to begin and end a block. Use MS SQL Insert Into syntax to insert the results of the stored procedure into the temp table. Use the appropriate data types (if you know them). Create a table with the number of columns required that will be returned from the stored procedure. I had to have the semicolons for this to work:
HOW TO RUN STORED PROC IN ORACLE SQL DEVELOPER TOOL CODE
It seems that MS SQL Server stored procedure was limited in that I got it to execute the stored procedure, but the Java code (in SQL Developer) obviously didn't know (or didn't check) that it was returning a rowset, so it doesn't display it. 1.7K Training / Learning / CertificationĪfter reading everyones comments, I was able to do the following.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.