Re: Calling a stored program unit in another one
Date: Tue, 19 May 1998 01:19:42 GMT
Message-ID: <6jqmnd$tfi$1_at_nnrp1.dejanews.com>
Christophe,
all you need is
GRANT EXECUTE ON X.GENEALERTES_VEHICULE TO Y; where X is ownere of stored procedure GENEALERTES_VEHICULE and Y is owner of a stored object you are having troubles with. NOTE: grant must me issued directly, not via role.
Solomon Yakobson.
In article <6jp84s$35h$1_at_platane.wanadoo.fr>,
"Christophe" <perinfo_at_wanadoo.fr> wrote:
>
> Hello! I'm Christophe from Paris.
>
> I'm always writing my stored program units with Oracle 7 and another error
> appears:
>
> "PLS-00201: identifier 'GENEALERTES_VEHICULE' must be declared"
>
> on the line:
>
> GENEALERTES_VEHICULE (PARAM_REF_VEHICULE,
> PARAM_REF_ALERTE,
> CORREC_NBJOURS,
> CORREC_NBKMS,
> CORREC_DATE,
> DATE_SYSTEME,
> NUM_EDITION);
>
> in order to calling this S.P.U. in another one.
>
> 'GENEALERTES_VEHICULE' has been created successfully.
>
> Please send your answers at lsa.perinfo_at_wanadoo.fr.
>
> Thanks and good bye...
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 03:19:42 CEST