HELP! Can I set Runtime Settings in Trigger ? [message #366841] |
Tue, 24 October 2000 16:16 |
Pete
Messages: 11 Registered: October 2000
|
Junior Member |
|
|
Hi,
I would like to know if I can set the NONBLOCKSQL
runtime setting to NO in the Before Form Trigger, and if so how ? I don't know how to reference the
parameter/setting !
I am doing this because I am periodically getting a ORA-01002 error when calling the report from Forms.
When I do an ADD_PARAMETER(NONBLOCKSQL=NO) when I call the report from Forms all works well. I want to add it to the report instead of the form. I tried saving the setting but am still getting the error anyway. I want to explicitly set the parameter/setting in the report.
Thanks in advance,
Pete
prodick@telcordia.com
|
|
|