Re: JDeveloper - parameters in view objects

On 18 Jul 2002 08:34:58 -0700, joemellors_at_aol.com (Joe Mellors) wrote:

>> Views do not allow parameters.
>> Your only escape is to refer to package variables in your view (the
>> package variables must be defined in the package specification, in
>> order to be public)
>
>Thanks for your response.
>Are you referring to views, packages as in the database objects
>because the view objects I'm working with are within JDeveloper and
>you are allowed to use parameters within them either by using
>:paramname or a question mark (?)
>I just don't know how to go about setting them as JDeveloper seems
>like a bit of a minefield at this early stage of using it.

[Quoted] I am referring to views in the database. You might be talking about ordinary resultsets. Many DBAs have been getting severe headaches the last few years caused by developers NOT using them.
If you want to be hated by your DBA, do not use them.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 18 2002 - 20:06:47 CEST