do i need to pass values in single quotes in IN clause while passing to procedure [message #417984] |
Wed, 12 August 2009 06:09  |
chaituu
Messages: 115 Registered: June 2008
|
Senior Member |
|
|
p_acct_id is a string varaiable ;values may go either single or multiple values like 'a' or 'a','b','c','d'.
how to pass these values in ex procedure and how to execute select statement.do i need to pass values with single quotes or without quotes.in this case do i need to use execute immediate statement or not?
procedure ex(p_acct_id varchar2) IS
select * emp
from accitd in (p_acct_id);
end ex;
|
|
|
|
|
|
|
|
|
|
|
|
|
|