Re: Web Application Server, PL/SQL, Dynamic Web Page

I am not too savvy with the Oracle database as I am still learning. Are there any other Oracle utilities I can use that will give me the desired results? If not, when you wrote you own procedure, how did you query the database - this is really where my problem is as well as getting the data display nicely. Right now I will be happy just to receive the data from the database. Thanks in advance

Michelle

Steve Jelfs wrote:

> Michelle Warner wrote:
> >
> > I am working with Web Application Server 3.0 and Oracle 7. I am
> > constructing a dynamic web page via a stored procedure which makes a
> > call to owa_util.tablePrint to retrieve the data from the database.
> > However, my data never returns and the process appears to be hung and I
> > must kill it. Here is the section of code which is causing me problems:
> >
> > htp.tableOpen('border');
> > more_data := owa_util.tablePrint('drawtabl', 'BORDER',
> > OWA_UTIL.PRE_TABLE, 'dwgnum, dwgtit, dwgtyp','where dwgnum = srch4',
> > 'Number, Title, Type');
> >
> > I connect to the database using a DAD and an Agent. Any
> > help/suggestions would be greatly appreciated. Thanks in advance
> >
> > Michelle
>
> I think you'll find that owa_util.tableprint contains a bug. The same
> thing happened to me a couple of months back using the same set up as
> you (except Webserver 2.1). Oracle told me not to use tableprint so
> ended up writing my own version.
>
> Sj
Received on Fri Feb 06 1998 - 00:00:00 CST