Scripts with parameters

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Valgardur
Posts: 165
Joined: Tue 24 Nov 2009 19:33

Scripts with parameters

Post by Valgardur » Tue 06 Oct 2020 12:13

I use TOraSql frequently to perform operations, but occasionally it would be great to be able to run multiple commands, I assume TOraScript is intended for that, but it does not allow parameters.. Would it be possible to add this? I realise I can user a stored procedure and I realise I can use two TOraSql, but it would be far cleaner to have this in one component.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Scripts with parameters

Post by MaximG » Wed 07 Oct 2020 13:52

TOraSQL and TOraScript are intended for different purposes, therefore we recommend to use TOraSQL for parameterized queries. You can use PL/SQL anonymous blocks to run parameterized commands.

Post Reply