I have solved my problem as your solution.Thanks.
Just another question:
I read the Help Page before to find my answer,and done as fllowing in the Hepe Page:
- img1.jpg (9.38 KiB) Viewed 3949 times
So,I write my sql like this:
Code: Select all
select @V2 as id,@V1 as name from dual
and got a "ORA-00936: missing expression " Error.
So,my question is:
Is the named parameter must be specified by the @ symbol?
or,can I use named parameter in Oracle?
I think it is better to use Data Source parameter to solved this problem,because I use Data Source parameter all the time.
Anyway,use the "Variable" is also OK. thanks again.