Scripts with parameters
Scripts with parameters
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
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.