Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
sys_context in the view and using in oracle forms
CREATE OR REPLACE VIEW QC_DAILY_VW
(DEPT_ID, QC_TYPE_ID, QC_SUBTYPE_ID, QC_DATES, CONTROL_NO)
AS
select a.dept_id,a.qc_type_id,
a.qc_subtype_id,b.qc_dates
from qc_dept_subtypes a,qc_daily b
where a.dept_id = b.dept_id(+)
and a.qc_subtype_id = b.qc_subtype_id(+)
and a.qc_type_id = b.qc_type_id(+)
--and a.dept_id = 11
and b.qc_dates(+) = to_date(sys_context('mydat
-------------------
In my forms I call this in the post query
my_pkg.test_context(:qc_de
First time the form is blank. when I close it and reopen then the data displays. Why is this happening.
(DEPT_ID, QC_TYPE_ID, QC_SUBTYPE_ID, QC_DATES, CONTROL_NO)
AS
select a.dept_id,a.qc_type_id,
a.qc_subtype_id,b.qc_dates
from qc_dept_subtypes a,qc_daily b
where a.dept_id = b.dept_id(+)
and a.qc_subtype_id = b.qc_subtype_id(+)
and a.qc_type_id = b.qc_type_id(+)
--and a.dept_id = 11
and b.qc_dates(+) = to_date(sys_context('mydat
-------------------
In my forms I call this in the post query
my_pkg.test_context(:qc_de
First time the form is blank. when I close it and reopen then the data displays. Why is this happening.
Asked:
Who is Participating?
This is the problem I have
sys-context.doc
sys-context.doc
I tried to set it in the when new block instance trigger of the view block. It still does not work. I commented tyhe line in post query and now I have it only in the when new block, but nothing works. But when I requery it brings the data.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
the view is based on the value of the context, so it must be set BEFORE you read the view.
The context won't change unless you change it, so setting it once on the form is sufficient.
to fix it, set it before the form's query executes