Declare Parameters ODP.NET

Leandro Borges · Post by **Leandro Borges** » Wed May 11, 2016 1:33 pm

Hello.
How do I declare parameters in Oracle? In SQL I use @.
Thank you.

Post by **HighAley** » Thu May 12, 2016 6:50 am

Hello, Leonardo.

You should use : instead of the @ symbol.

Thank you.

Leandro Borges · Post by **Leandro Borges** » Thu May 12, 2016 5:38 pm

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.

Post by **Alex K.** » Fri May 13, 2016 7:49 am

Hello,

Some problem in your query.
Please send us your report with test data for analysis.

Thank you.

Leandro Borges · Post by **Leandro Borges** » Fri May 13, 2016 12:00 pm

Hello.
Already solved.
Thank you.

Post by **Alex K.** » Fri May 13, 2016 12:06 pm

Hello,

Ok.
Let us know if you need any additional help.

Thank you.