Handling bind variables in SQL window (new feature request)
- Thread starter vlevi
- Start date
ARAM1 bind variables.
You can use the Test Window for this, which supports bind variables and select statements.
Bind variables in the SQL window would be nice. SQL in Oracle reports uses a lot of bind variables too.
This is a little different, but this works. Use a test window for the SQL statement instead of a SQL window. Enter the values for the Bind variables below the test window. After you execute it, there will be a SQL tab containing the output.
By the way, maybe I was dreaming, but I thought that in version 6 it would enter the bind variable names for me when I converted from a SQL window to a test window. In version 7, it doesn't seem to do that anymore.
You have to be carefull, but sometimes I have also just replaced all ":" with "&" and put it back when I was done testing.
Mike
This is a little different, but this works. Use a test window for the SQL statement instead of a SQL window. Enter the values for the Bind variables below the test window. After you execute it, there will be a SQL tab containing the output.
By the way, maybe I was dreaming, but I thought that in version 6 it would enter the bind variable names for me when I converted from a SQL window to a test window. In version 7, it doesn't seem to do that anymore.
You have to be carefull, but sometimes I have also just replaced all ":" with "&" and put it back when I was done testing.
Mike
Similar threads
- Discussion
- Discussion