Re: Use bind variables in a view

From: Gunter Herrmann <notformail0405_at_comcast.net>
Date: Sat, 19 Nov 2005 15:08:39 -0500
Message-ID: <437f8649$0$20845$9b4e6d93@newsread2.arcor-online.net>

Hi!

Sybrand Bakker wrote:

> Basically what you need to do (and it works like a charm) is

> - set up a package
> - define the variables in the package spec
> - have one procedure per variable (in the package) to set the variable
> - have one function per variable (in the package) to get it's value
> - use the function in the view definition

Alternatively set up the variables in the package body (before functions and procedures), rest as above. This makes sure nobody can mess with your variables without using your set procedure (that can include some validation).

brgds

-- 
Gunter Herrmann
Naples, Florida, USA

Received on Sat Nov 19 2005 - 14:08:39 CST