Re: Internal Function Call within a SELECT statement
From: Gerd Volberg <gerd.volberg_at_netcologne.de>
Date: Tue, 04 Aug 1998 22:27:11 +0200
Message-ID: <35C76E9F.62E74B56_at_netcologne.de>
Date: Tue, 04 Aug 1998 22:27:11 +0200
Message-ID: <35C76E9F.62E74B56_at_netcologne.de>
Hi Kevin,
in addition to Arjan, here the explanation of wnds, rnds, wnps, rnps :
WNDS write no data state.
RNDS read no data state.
WNPS write no package state.
RNPS read no package state.
f.e. you have get_govt_id in a package, and write a package variable in your
function. Then you cannot use the pragma restriction WNPS. The same with RNPS,
when you read a package variable. The same meanings you have in the DATA
statements. If you have some in your function, you cannot use this abbreviation
in your restriction list. Sometimes you have only pragmas like (get_govt_id,
WNDS).
Mach´s gut
Gerd Volberg
Received on Tue Aug 04 1998 - 22:27:11 CEST