Discussion:
Bind Variable Peeking with Oracle Forms & Reports
(too old to reply)
Allen, Brandon
2010-03-04 20:41:15 UTC
Permalink
Hi List,

I've been struggling with this issue for a few months and haven't gotten very far with Oracle Support, so I'm hoping some of you may be able to shed some light on it for me. I'm working with a 3rd party application written in Oracle Forms & Reports and I've noticed that bind variable peeking is not being down for some of the queries coming from the application, but for other queries it is. When the peeking isn't done, I see the message "No bind buffers allocated" in the output of a 10053 trace, which seems to indicate that the bind variable value wasn't specified at parse time on the client-side by Forms/Reports, in which case the database wouldn't be able to peek at it. I've been able to reproduce the same "No bind buffers allocated" message by using dbms_sql as shown here:

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2444907911913#55014877907946

So I guess this is a known issue (although not documented) that bind variable peeking isn't done with dbms_sql, but I can't find any documentation or anything in MOS or anywhere else mentioning this as a known issue with Oracle Forms & Reports. Has anyone else seen this behavior? Is it documented anywhere? Do you have any idea why some queries would have their bind variable values set and peeked, but others would not?

Thanks,
Brandon


________________________________
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
Allen, Brandon
2010-03-10 16:25:18 UTC
Permalink
Sorry for the repost, but I'm just trying this one more time during a different timezone and with more concise wording since I didn't get any replies the first time:

Has anyone else noticed queries coming from Oracle Forms & Reports not having their bind variables peeked and/or reporting "No bind buffers allocated" in a 10053 trace? Any idea what could be causing it? I'm seeing this with Forms & Reports 10.1.2.3 on a 10.2.0.4 database. For more detail, please see my original post below.

Thanks,
Brandon



--Original post from last week--

I've been struggling with this issue for a few months and haven't gotten very far with Oracle Support, so I'm hoping some of you may be able to shed some light on it for me. I'm working with a 3rd party application written in Oracle Forms & Reports and I've noticed that bind variable peeking is not being down for some of the queries coming from the application, but for other queries it is. When the peeking isn't done, I see the message "No bind buffers allocated" in the output of a 10053 trace, which seems to indicate that the bind variable value wasn't specified at parse time on the client-side by Forms/Reports, in which case the database wouldn't be able to peek at it. I've been able to reproduce the same "No bind buffers allocated" message by using dbms_sql as shown here:

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2444907911913#55014877907946

So I guess this is a known issue (although not documented) that bind variable peeking isn't done with dbms_sql, but I can't find any documentation or anything in MOS or anywhere else mentioning this as a known issue with Oracle Forms & Reports. Has anyone else seen this behavior? Is it documented anywhere? Do you have any idea why some queries would have their bind variable values set and peeked, but others would not?


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l

Loading...