hi...

i want to write a procedure which can take inputs from user at runtime (not at compile time). "&" didnt work.

please tell me syntax for the same...

Did you use ACCEPT command ?

How to use accept command

Satyajith,

The accept command can be used to prompt for a value for a substitution variable.

When no prompt is supplied it will display a message to enter a value for variable.

If the variable already exists the old value will be shown so the user can change it.

Syntax:
ACCEPT variable [PROMPT text ];

Eg:

Display a message to enter an employee number before getting the data for that employee:

ACCEPT myempno PROMPT 'Enter an employee number';
select * from emp where empno = &myempno;


OR

Display a message to enter a department number before getting the department data. The value for department should be preset to 20, the user can change it at the prompt:

DEFINE mydeptno = 20;
ACCEPT mydeptno PROMPT 'Enter the department number';
select * from dept where deptno = &mydeptno;


Thanks & Regards,
Riju.

u can use the & like
select * from emp where deptno=&deptno;

u can pass parameter before executing sql qry.
In procedure,we can not pass inputs in middle of the procedure process.
but at time of execution ,we can pass parameters to procedure (only when the procedure is Parameterized)

__________________
Sireesha