Re: Oracle stored procedures and crystal reports

Do a show errors or select * from user_errors in sql*plus. It will show you the exact error message. From here, the code looks valid. It seems we need to have your error message to resolve it, we may be missing context.

Hth,

--
Sybrand Bakker, Oracle DBA
<c.ng_at_ctru.auckland.ac.nz> wrote in message news:3822469c.197384500_at_news.auckland.ac.nz...
> I am trying to create a stored procedure which updates a table
> and then returns the records in the table so that a report
> can be produced using Crystal Reports.
>
> I have followed the instructions in the seagate community technical
> papers but can't seem to get the stored procedure to work. When I try
> to describe the procedure, SQL*Plus says that the object is invalid.
>
> I have typed in the following code to create a cursor type:
>
> create or replace package cursor_types as
> type emp_cur is ref cursor return emp%rowtype;
> end cursor_types;
>
> Then I typed in the following code to create the stored procedure.
>
> create or replace procedure
> get_data (emp_cv in out cursor_types.emp_cur) as
> begin
> open emp_cv for select * from emp;
> end get_data;
>
> Can anyone please tell me what is wrong.
>
> Thank you.
Received on Fri Nov 05 1999 - 01:06:41 CST