Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

I have a packaged named 'package' and a stored procedure sp1. From the command window in SQL Developer, runningexecute package.sp1(parameters);results in an ORA-00900 error: invalid SQL statement ...

When PROC SQL executes the view, the stored query assigns the libref and establishes the DBMS connection using the information in the LIBNAME statement. The scope of the libref is local to the view, ...