Re: Maddening - Creating a stored procedure for use in Crystal Reports

From: Ken Denny <ken_at_kendenny.com>
Date: Sun, 10 Mar 2002 13:50:08 GMT
Message-ID: <Xns91CD5AEBB3CB9kendenny_at_65.82.44.7>

"Some person" <thesynner_at_hotmail.com> wrote in news:Mhwi8.10469$Yv2.5045_at_rwcrnsc54:

> Again, thanks for your response.
>
> I modified the statement to accomodate our db, and while the package
> creates, the package body gets
> compilation errors. I'm including the revised statement in hopes that
> you'll be able to spot the problem...
>

The package body needs to have the same name as the package.
>
> **Works Fine:
> CREATE OR REPLACE PACKAGE pkgFIRES_BY_CAUSE AS
> TYPE rcursor IS REF CURSOR;
> PROCEDURE procFIRES_BY_CAUSE (prmBATTALION IN VARCHAR2, r_rcursor OUT
> rcursor);
> END;
>
> **Compilation Errors:
> CREATE OR REPLACE PACKAGE BODY bodFIRES_BY_CAUSE

                                  ^^^^^^^^^^^^^^^^^

change this to the package name pkgFIRES_BY_CAUSE (or leave the pkg and bod out altogether).

-- 
Ken Denny
http://www.kendenny.com/

Philosophy is questions that may never be answered. Religion is answers 
that may never be questioned.

Received on Sun Mar 10 2002 - 14:50:08 CET