| bio | website | darrylbraaten.com |
|---|---|---|
| location | Vancouver, Canada | |
| age | 39 | |
| visits | member for | 1 year, 11 months |
| seen | Mar 29 at 17:06 | |
| stats | profile views | 2 |
|
Apr 4 |
awarded | Notable Question |
|
Apr 17 |
awarded | Popular Question |
|
Jun 2 |
awarded | Scholar |
|
Jun 2 |
accepted | Sqlplus parameterized query via file |
|
Jun 1 |
awarded | Supporter |
|
Jun 1 |
awarded | Student |
|
Jun 1 |
comment |
Sqlplus parameterized query via file Actually the issue we have is the paramertized query gets stuck with a bad plan and performs poorly. The DBA will test it with a plain sql statement and report nothing is wrong. For some some small queries doing parameters manually is ok for some we need a better way to provide them to the dba. Do you have an example that uses UTLFILE do read in parameters? |
|
Jun 1 |
asked | Sqlplus parameterized query via file |