Page 1 of 1

Scripts with parameters

Posted: Tue 06 Oct 2020 12:13
by Valgardur
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.

Re: Scripts with parameters

Posted: Wed 07 Oct 2020 13:52
by MaximG
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.