| lexical parameters and procedure [message #88195] |
Tue, 30 April 2002 07:08  |
Angie
Messages: 12
Registered: April 2002
|
Junior Member |
|
|
Does anyone have an example that you would be willing to share, of using lexical parameters for the where clause in a query. I would like to see the procedure that defines the lexical parameter as well.
Thanks.
|
|
|
|
| Re: lexical parameters and procedure [message #88220 is a reply to message #88195] |
Wed, 15 May 2002 03:18  |
jawadg
Messages: 19
Registered: May 2002
|
Junior Member |
|
|
create a parameter named p_where_clause with following property settings (datatype=character) under data model node.
then try this query
(select * from emp
p_where_clause;)
-----------Allah Hafiz.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
