Re: Calling an SQR from the WEB

[Gracen Duffield <itzgee@PRISMNET.COM>]

I don't actually call SQR's from the Web, but I do sort of do something like
that.

We have one NT box that is running Oracle 8.  It has non-peoplesoft
applications on it, including the oracle web server.

We are running several peoplesoft instances on another unix box.  It has
Oracle 7 on it, and does not have the Oracle web server on it.  We have real
space problems on this box, and so we do not run the webserver on it.

The database administrator at our office created a "listener" on the Oracle
8 box that links up to the Oracle 7 box.

I have used PL/SQL to query the PeopleSoft data.  The pl/sql runs on the
Oracle 8 box and pulls data from Oracle 7 / Peoplesoft.

I have had performance problems with this so far -- it takes forever for
some reports -- but I am optimistic that it will eventually work out.



Gracen Duffield
itzgee@prismnet.com
gduffiel@genesis.tdhca.state.tx.us
Programmer/Analyst, Texas Department of Housing and Community Affairs

-----Original Message-----
From: Gary Ogren <g-ogre@NGWMAIL1.NDIS.UMN.EDU>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Thursday, September 10, 1998 11:40 AM
Subject: Calling an SQR from the WEB


We purchased PeopleSoft and with it SQR3.  We have an Oracle database
version
7.3.  We have set up WEB pages for users to input usernames, passwords, and
parameters in order to get reports from the database (these pages were set
up to
read Sybase databases before we had PeopleSoft).  Can we use our WEB front
concept to get access to the Oracle database and provide parameters to an
SQR
report?

Our WEB person says that the SQR would have to run from a command line.  We
are
running on an WindowsNT server.