Question : I have deployed a package with 2 package parameters which had their values set inside the package prior […]
Tag: parameter
Programatically scan a stored procedures parameters
Question : I have been trying to figure out how to scan a stored procs parameters from the execution plan. […]
Oracle SQL script – passing a parameter
Question : I have an Oracle SQL script like this: delete FROM activ_princ where id in (select ap.id FROM activ_princ […]
Mysterious procedure calls without parameters – but no exceptions generated
Question : I’ve been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient […]
Stop NLS settings in init.ora getting overridden by environment variable
Question : We have a databases server that is used for development which has hundreds of database instances for different […]
Why does this stored proc cause a clustered index scan, but seek when using OPTION RECOMPILE?
Question : I think I may know the answer based on my research, but am looking for confirmation on how/why […]
Why does this stored proc cause a clustered index scan, but seek when using OPTION RECOMPILE?
Question : I think I may know the answer based on my research, but am looking for confirmation on how/why […]
Can multiple Oracle databases share a single parameter file?
Question : I’m a developer working on an application team that supports a system with one production database and 4 […]
Make query depend on input in PostgreSQL function
Question : I have a simple query: CREATE OR REPLACE FUNCTION companies_all_teams( IN _company_name text = NULL, IN _company_id int […]
Parameterized Dynamic TSQL – Dynamic Parameters
Question : We have a situation where effectively the same report is requested by different customers but they: Don’t want […]