Bindings?

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
TimTaylor
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Bindings?

Post by TimTaylor » Wed 22 Nov 2017 14:16

Hi there,

how will standard bindings like this work?

Code: Select all

select *
from ht_symbo
where  SYMBOLISCHERNAME like UPPER('%&symb_name%')
and datenbank = 'VVT'

.jp
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Bindings?

Post by .jp » Wed 22 Nov 2017 14:27

Hello,

Thanks for the post.
Could you please tell us what product you are using and its version.
Also please provide a server version.

Best Regards.

TimTaylor
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Re: Bindings?

Post by TimTaylor » Wed 22 Nov 2017 14:46

I just tried dbforge studio 3.10.12 with oarcle 12

Toad and SQL Navigator are showing popup windows for an entry for this, dbforge studio just complains about no binding.

YuriP
Posts: 11
Joined: Fri 27 May 2016 12:49
Location: Devart
Contact:

Re: Bindings?

Post by YuriP » Mon 27 Nov 2017 09:43

Hello,

dbForge Studio for Oracle uses symbol colon for parameters binding:

Code: Select all

select *
from ht_symbo
where  SYMBOLISCHERNAME like UPPER(:var)
and datenbank = 'VVT'
Best regards,

TimTaylor
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Re: Bindings?

Post by TimTaylor » Wed 29 Nov 2017 06:37

Oh ok strange, why dont use the standard here?

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Bindings?

Post by alexa » Wed 29 Nov 2017 19:05

You can add a suggestion on our UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/132 ... for-oracle

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Post Reply