Re: Stored Procedure VS Package

yewpc_at_my-dejanews.com wrote in message <7eethc$dek$1_at_nnrp1.dejanews.com>...
>Hi everyone :
>
>If that true Stored Procedure will fetch all the selected records at once
to
>the calling program but Package will fetch record by record of the selected
to
>the calling program (like return a record to calling program upon request)
?
>
>In other word, Stored Procedure is use for single record return
>but package is used for multiple record return. Am I right ??
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

No. Not at all.

You cannot call a package. You can call a package procedure, however, but a package procedure does not differ from a separately stored procedure in any way similar to what you have mentioned.

Also, a procedure does not implicitly fetch any records. You will have to do that through implicit or explicit cursors.

Maybe I don't understand at all what you are trying to do? Please post an example.

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Apr 07 1999 - 05:37:19 CDT