Re: g
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Feb 2006 08:58:01 -0800
Message-ID: <1139417872.914354_at_jetspin.drizzle.com>
>>zafri1936 wrote:
>>
>>>I made a little form application. The purpose of this application is to
>>>generate explain plan for a particular SQL. Some sql scripts run
>>>internally in order to populate the result on form's screen after
>>>pressing the form's button but I am getting windows error during
>>>running the sql scripts from form 6i.
>>>
>>>I am using forms 6i with patch 17 with Oracle 10G database on windows
>>>2000 professional on same computer.
>>>This application runs fine with 8i.
>>>Please inform me where the problem is and how to overcome it.
>>>
>>>Zafri.
>>
>>Have no idea as you've provided a wholly inadequate account of what
>>you are doing.
>>
>>But it should be noted that the proper way to generate Explain Plan
>>output in 10g is with the DBMS_XPLAN package and rather than using
>>plan_table using the plan_table$. You might want to spend a few
>>moments with $ORACLE_HOME/rdbms/admin/catplan.sql.
>>
>>It won't solve your forms problem but then as I said before I have
>>no idea what you are doing, or not doing, from your description.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
Date: Wed, 08 Feb 2006 08:58:01 -0800
Message-ID: <1139417872.914354_at_jetspin.drizzle.com>
zafri1936 wrote:
> Following error I am getting during execution of the sql script: > > Oracle Sql Plus has encountered a problem and needs to close. > > > > Thanks > > Zafri > > > > > DA Morgan wrote: >
>>zafri1936 wrote:
>>
>>>I made a little form application. The purpose of this application is to
>>>generate explain plan for a particular SQL. Some sql scripts run
>>>internally in order to populate the result on form's screen after
>>>pressing the form's button but I am getting windows error during
>>>running the sql scripts from form 6i.
>>>
>>>I am using forms 6i with patch 17 with Oracle 10G database on windows
>>>2000 professional on same computer.
>>>This application runs fine with 8i.
>>>Please inform me where the problem is and how to overcome it.
>>>
>>>Zafri.
>>
>>Have no idea as you've provided a wholly inadequate account of what
>>you are doing.
>>
>>But it should be noted that the proper way to generate Explain Plan
>>output in 10g is with the DBMS_XPLAN package and rather than using
>>plan_table using the plan_table$. You might want to spend a few
>>moments with $ORACLE_HOME/rdbms/admin/catplan.sql.
>>
>>It won't solve your forms problem but then as I said before I have
>>no idea what you are doing, or not doing, from your description.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
- Do not top post.
- Do not top post.
- Do not top post.
- Your explanations are inadequate and no help is possible.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Feb 08 2006 - 17:58:01 CET