Home » RDBMS Server » Server Administration » Passing parameters to a Select Stmt
Passing parameters to a Select Stmt [message #372179] Wed, 17 January 2001 14:35 Go to next message
Eric B
Messages: 1
Registered: January 2001
Junior Member
Hello Everyone.

I am trying to pass a parameter to a select statement within a view, but I am not getting the results that I am expecting. I have this working in the 'Where' part of the select statement, but not directly in the select.

Can anyone tell me where I am going wrong? Thanks!

Select col1_id, col2_id, col3_id, col4_id, col5_id, col6_id, table.package.getparam(2) mth1

I would like the parameter to be either a list separated by commas if possible.

Thanks for the help!!

Eric B.
Re: Passing parameters to a Select Stmt [message #372180 is a reply to message #372179] Wed, 17 January 2001 14:46 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
see http://www.orafans.com/ubb/Forum6/HTML/001125.html
Previous Topic: Re: help with tables...
Next Topic: Re: Random number generation in SQL/ PL-SQL
Goto Forum:
  


Current Time: Wed May 15 14:27:48 CDT 2024