Page 1 of 1
Declare Parameters ODP.NET
Posted: Wed May 11, 2016 1:33 pm
by Leandro Borges
Hello.
How do I declare parameters in Oracle? In SQL I use @.
Thank you.
Re: Declare Parameters ODP.NET
Posted: Thu May 12, 2016 6:50 am
by HighAley
Hello, Leonardo.
You should use : instead of the @ symbol.
Thank you.
Re: Declare Parameters ODP.NET
Posted: Thu May 12, 2016 5:38 pm
by Leandro Borges
Hello.
My name is Leandro.
Right. One thing I noticed, the parameter name can not repeat within the select if no the ORA-01008 error occurs. Why this happens?
Thank you.
Re: Declare Parameters ODP.NET
Posted: Fri May 13, 2016 7:49 am
by Alex K.
Hello,
Some problem in your query.
Please send us your report with test data for analysis.
Thank you.
Re: Declare Parameters ODP.NET
Posted: Fri May 13, 2016 12:00 pm
by Leandro Borges
Hello.
Already solved.
Thank you.
Re: Declare Parameters ODP.NET
Posted: Fri May 13, 2016 12:06 pm
by Alex K.
Hello,
Ok.
Let us know if you need any additional help.
Thank you.