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

Thanks for the post, this is interesting for 2 reasons.

Aside from learning they must be named the same thing, I inferred from this that since a package isn't required, a procedure is?

I have been creating exactly waht you see here, and even though I had changed the name last night, it still didn't execute correctly.

Can you please provide an overview of the requirements for creating a stored procedure?

As in:

You must create a package

You must creat a procedure

Then any naming rules.

Granting execution rights?

Thanks again for you help.

"Ken Denny" <ken_at_kendenny.com> wrote in message news: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 - 19:59:10 CET