On Jul 22, 4:30 am, martinw <martin.wilkin...@googlemail.com> wrote:
> 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 have the results since you've passed in a sys_refcursor; try
print <refcursor you passed in>
to display those results.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
