RE: anyone with html db experience?
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 14 May 2004 09:51:22 -0400
Pat, Since it is same software as Asktom try this ...
If you look at asktom site URLs, towards right, there is a parameter
with value N, when you change it to Y, it displays trace of commands it
executes. In HTMLDB, you could do something similar. I know it has some
trace built into it. Try it. No guarantees how it will work, but 'leave
no stone unturned' ...
Raj
------------------------------------------------------------------------
--------=20
Rajendra dot Jamadagni at nospamespn dot com=20
All Views expressed in this email are strictly personal.=20
select standard_disclaimer from company_requirements;=20
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pat Hildebrand
Sent: Thursday, May 13, 2004 8:06 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: anyone with html db experience?
The mention on this list of html db as the replacement for WebDB, was
very timely for us. It came just as we were coming close to solving all
the problems of getting Portal (v2) to work so that we could test using
the undocumented Portal reports for the reports, in a pl/sql web
application that had been developed in 8i on solaris, which had been
written using WebDB. This application is now moving to 9iR2 on Linux (I
know that it is Red Hat but not the version although - since supported I
would think enterprise).
Here is the situation. I was assigned the task of determining if we
could in fact use html db for our reports. I do not have all of the
access that I need to actually move a report to our test environment
since it is not yet ready. One of the sys admins has set up a non-secure
(http) html db on a small workstation for me to investigate. Since the
application uses https and interacts with other Oracle instances, what
Iim trying to do will be a show stopper if I don't get it figured out
because what we need is more complicated.
The WebDB reports have two pages: one for the parameters and one for the
report itself. The reports are sql queries with bind variables passed in
from the parameters page. I'm trying to use two pages to have two
paramenters (from select lists) passed from one page to another where
the report is a sql query using bind parameters.
I have been able to set up the page for the parameters and the query
that I'm using returns data when run from the SQL command processor with
the values that I'm trying to select hard coded. However, if I try to
run the application it comes back with "no data found". I'm guessing
that I'm failing to get the parameters to the query.
I have looked at Oracle's how to pages, the 10g documentation for html
db, the sample applications, the source for the generated parameter
page, tried google, and even just trying things without being sure that
they should make any changes that I could see. The obvious (to
me) things that I have tried are the item names for the names of the
bind variables and the names in the html tags (from viewing source)
without any luck.
This may just be a case of my looking at something and not seeing it but
I'm running up against the go/no go deadline so I don't really have time
to go off on something else long enough that coming back is really a
fresh start. Therefore, could someone either point me to where I can
find how to get the parameters into the bind variables or tell me how to
do it?
Any help would be greatly appreciated.
Pat
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
