Hi
I am learning Oracle (not by choice!) using 'Oracle SQL Developer' and
Oracle XE.
I have written a stored procedure that when called through crystal
reports produces the correct results.
All I want to do is get the output from the stored procedure to
display within sql developer, I presume in the results window.
At the moment I have to run Crystal Reports to check the output from
the stored procedure should I make any changes to it.
In SQL Server 2005 Managment Studio I just ask to execute the stored
procedure and it then prompts me for the parameters (if it has any)
and hey presto the result set come back in the Managment Studio window
- No problems!
That all I want to do in Oracle, please can you help.
Regards
Martin.
Here's the stored procedure
create or replace
PROCEDURE PROCEMPDEP
(tstCursor in out sys_refcursor
,vDeptID IN departments.department_id%TYPE
,vStartDate IN employees.hire_date%TYPE
,vEndDate IN employees.hire_date%TYPE
) is
BEGIN
OPEN tstCursor FOR
SELECT
e.first_name,
e.last_name,
d.department_id
FROM employees e
INNER JOIN departments d
ON e.department_id=d.department_id
WHERE d.department_id=vDeptID
AND e.hire_date BETWEEN vStartDate AND vEndDate;
END PROCEMPDEP;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
