What is the use of Oralce Package for Crystal ?

[nkshah]

Experts,

i already developed one Storec Procedure with Ref Cursor in that.

and i defined packages and package body with PRocedrue and Ref Cursor.

Everything Works Perfect.

I added procedure in Crystal Reports and Working Excellent.

I want to know that, Why we need to defined package with Procedure and Ref Cursor ?

Because, one Oracle PRocedure compiled and Run, we directly adding Procedure in Reports and Package is
not coming in Picture.

Then, what is the use of Package here ? (i know kfundamental about Oracle Package - like a Function overloading in C++)

But i want to understand in term so Crystal Reports usage ...

i m using Oracle !0 G and Crystal XI.

Any help and explanation is well come.

Thanks..

 

[Turkbear]

Hi,
This was answered for you in the Oracle 10G forum.
Crystal does not care about the package but does need that REF CURSOR to 'see' the dataset - The use of the package in Oracle is just good practice - see this:

http://download.oracle.com/docs/cd/A58617_01/server.804/a58227/ch14.htm

- especially the sections on why to use a package.





To Paraphrase:"The Help you get is proportional to the Help you give.."