sql psp portal - help

[Guest]

I was recently asked to resurrect an Oracle project shelved
several years ago. I know almost nothing about Oracle. So,
I barely know where to start.

There is a windows application that connects to an Oracle server
via the Internet, and I was told that the "oracle code was developed
against Oracle 8 and makes use of their web portal stuff" and it uses
PL/SQL.

The oracle code consists of a bunch of .sql and .psp files. I was
told that if I loaded the oracle code into oracle, it should work.

I started by downloading Oracle9i Database and installing it on
XP Pro. But, now I think I need the Application Server.

Do I need the Application Server?
Do I need the Database?
How do I get the code into Oracle?
Will there be a problem with using code for Oracle 8 with a newer
version?

Would there be any difference/problem using Linux or Solaris
instead of XP Pro if the code was originally developed under Windows?

Any help is appreciated. Thank you.

[Daniel Morgan]

cynthih@yahoo.com wrote: I was recently asked to resurrect an Oracle project shelved several years ago. I know almost nothing about Oracle. So, I barely know where to start. There is a windows application that connects to an Oracle server via the Internet, and I was told that the "oracle code was developed against Oracle 8 and makes use of their web portal stuff" and it uses PL/SQL. The oracle code consists of a bunch of .sql and .psp files. I was told that if I loaded the oracle code into oracle, it should work. I started by downloading Oracle9i Database and installing it on XP Pro. But, now I think I need the Application Server. Do I need the Application Server? Do I need the Database? How do I get the code into Oracle? Will there be a problem with using code for Oracle 8 with a newer version? Would there be any difference/problem using Linux or Solaris instead of XP Pro if the code was originally developed under Windows? Any help is appreciated. Thank you.

You don't NEED the app server based on my impression of your posting but
your post is so completely devoid of critical information it is truly
impossible to tell you what you do need.

One could start with Oracle 8 and ask you to translate that into an
actual version number and continue from there.

My guess is that you are going to need a very senior consultant to
be successful. If management can afford it contact me off-line and
I will try to refer you to someone nearby.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Guest]

I wished I didn't have to be so vague, but part of the problem
is I don't know much more.
One could start with Oracle 8 and ask you to translate that into an actual version number and continue from there.

I don't know what version of Oracle 8 it was, and Oracle 8 is
no longer available for download. So, unless I can find a copy
of Oracle 8, I'm not going to be able to start there.

Maybe someone could explain to me how to run psp and sql files
under Oracle 9 or 10.

Thanks.

[GreyBeard]

On Sun, 20 Mar 2005 14:33:14 -0800, cynthih wrote:
Any help is appreciated. Thank you.

One place is the Oracle OTN PHP technology center.

http://www.oracle.com/technology/tech/opensource/index.html
http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html

[Mark C. Stock]

<cynthih@yahoo.com> wrote in message
news:1111453641.186417.110020@f14g2000cwb.googlegroups.com...I wished I didn't have to be so vague, but part of the problem is I don't know much more. One could start with Oracle 8 and ask you to translate that into an actual version number and continue from there. I don't know what version of Oracle 8 it was, and Oracle 8 is no longer available for download. So, unless I can find a copy of Oracle 8, I'm not going to be able to start there. Maybe someone could explain to me how to run psp and sql files under Oracle 9 or 10. Thanks.

Cynthih,

PSP probably refers to 'PL/SQL Server Pages' -- (not the PHP language as
indicated in another post) which was intended by Oracle to be a PL/SQL
equivalent of ASP or JSP, but actually requires translation into PL/SQL
stored procedures (forget the exact tool that's used-- it's really, IMO, not
a good approach to web development).

The bottom line is that Oracle's mod_plsql Appache module is needed (also
referred to as the PL/SQL Web Toolkit) -- which is typically part of
Oracle's Application Server installation.

If you are unfamiliar with the Oracle database, I would not recommend that
you try to get the application to work without help from an experienced
Oracle developer -- there's a lot to learn, and it's tougher when you're
trying to get someone else's code to work.

++ mcs

[Manish KUmar]

Hi Mark,
I have been going through the post and the replies. The last one
below is nearly correct. The only thing not right is calling "Apache
mod_plsql" as Oracle Web Toolkit. The latter is a pl/sql toolkit that
contains Oracle Packages that are used in Web application development.
To come straight to the point you can load any ".PSP" file into the
database with the loadpsp command as given below:
"loadpsp -replace -user <un>/<pw>[@<conn.str>] file1.psp file2.psp"

The above command helps you load file1.psp and file2.psp into an Oracle
database. For beginners on PSP please refer the following url, which is
really great:
http://www.oracle-base.com/articles/9i/PLSQLServerPages9i.php

In case you have any queries/questions on PSP technology, feel free to
contact me on manishdeshpande@gmail.com, I would prefer that you
contact me thru this forum/group as it will help in knowledge
dissemination to many people.

Regards.
Manish.

Mark C. Stock wrote: <cynthih@yahoo.com> wrote in message news:1111453641.186417.110020@f14g2000cwb.googlegroups.com...I wished I didn't have to be so vague, but part of the problem is I don't know much more. One could start with Oracle 8 and ask you to translate that into an actual version number and continue from there. I don't know what version of Oracle 8 it was, and Oracle 8 is no longer available for download. So, unless I can find a copy of Oracle 8, I'm not going to be able to start there. Maybe someone could explain to me how to run psp and sql files under Oracle 9 or 10. Thanks. Cynthih, PSP probably refers to 'PL/SQL Server Pages' -- (not the PHP language
as indicated in another post) which was intended by Oracle to be a
PL/SQL equivalent of ASP or JSP, but actually requires translation into
PL/SQL stored procedures (forget the exact tool that's used-- it's really,
IMO, not a good approach to web development). The bottom line is that Oracle's mod_plsql Appache module is needed
(also referred to as the PL/SQL Web Toolkit) -- which is typically part of Oracle's Application Server installation. If you are unfamiliar with the Oracle database, I would not recommend
that you try to get the application to work without help from an
experienced Oracle developer -- there's a lot to learn, and it's tougher when
you're trying to get someone else's code to work. ++ mcs

[Mark C. Stock]

"Manish KUmar" <manishdeshpande@gmail.com> wrote in message
news:1111496853.936879.48370@l41g2000cwc.googlegroups.com... Hi Mark, I have been going through the post and the replies. The last one below is nearly correct. The only thing not right is calling "Apache mod_plsql" as Oracle Web Toolkit. The latter is a pl/sql toolkit that contains Oracle Packages that are used in Web application development. To come straight to the point you can load any ".PSP" file into the database with the loadpsp command as given below: "loadpsp -replace -user <un>/<pw>[@<conn.str>] file1.psp file2.psp" The above command helps you load file1.psp and file2.psp into an Oracle database. For beginners on PSP please refer the following url, which is really great: http://www.oracle-base.com/articles/9i/PLSQLServerPages9i.php In case you have any queries/questions on PSP technology, feel free to contact me on manishdeshpande@gmail.com, I would prefer that you contact me thru this forum/group as it will help in knowledge dissemination to many people. Regards. Manish. Mark C. Stock wrote: <cynthih@yahoo.com> wrote in message news:1111453641.186417.110020@f14g2000cwb.googlegroups.com...I wished I didn't have to be so vague, but part of the problem is I don't know much more.> One could start with Oracle 8 and ask you to translate that> into an actual version number and continue from there. I don't know what version of Oracle 8 it was, and Oracle 8 is no longer available for download. So, unless I can find a copy of Oracle 8, I'm not going to be able to start there. Maybe someone could explain to me how to run psp and sql files under Oracle 9 or 10. Thanks. Cynthih, PSP probably refers to 'PL/SQL Server Pages' -- (not the PHP language as indicated in another post) which was intended by Oracle to be a PL/SQL equivalent of ASP or JSP, but actually requires translation into PL/SQL stored procedures (forget the exact tool that's used-- it's really, IMO, not a good approach to web development). The bottom line is that Oracle's mod_plsql Appache module is needed (also referred to as the PL/SQL Web Toolkit) -- which is typically part of Oracle's Application Server installation. If you are unfamiliar with the Oracle database, I would not recommend that you try to get the application to work without help from an experienced Oracle developer -- there's a lot to learn, and it's tougher when you're trying to get someone else's code to work. ++ mcs

you must be new around here....

thanks for the reminder on loadpsp -- as i mentioned, i do not recommend it
as a development path, as it is cumbersome to organize and maintain project
code, so i had forgotten what the command is to translate the PSP files into
PL/SQL procedures.

you're splitting hairs on terminology, but to be more precise, mod_plsql is
the Apache module that is required when using the Web PL/SQL Toolkit, which
is the set of packages required to use the mod_plsql -- both of which are
required when using PSP files and loadpsp.

++ mcs

[GreyBeard]

On Mon, 21 Mar 2005 21:35:53 -0500, Mark C. Stock wrote:
(not the PHP language as indicated in another post)

Ouch - that'll teach me to answer the question and not what I
thought I read. To make amends, here is a relevant answer:

Basically the process is:

1) create a stored procedure, or package, in the database. That should
use the UTL_HTP (and related) to do the database operations and format any
results that should go back to the originator (browser)

2) Access the package from a client, such as a browser, through an OHS
[Oracle HTTP Server Powered By Apache] and mod_plsql. This could be the
OHS server embedded with the database that supports iSQLPLUS, although
Oracle seems to be pushing the App Server to handle mod_plsql requests.

3) To do something equivalent to ASP or JSP, you can write a PL/SQL Server
page that embeds PL/SQL in a primarily HTML page. SOme additional info
from the DB side is in the "Application Developer's Guide - Fundamentals"
in the sections

Debugging PL/SQL Server Page Problems
Include Directive
Loading the PL/SQL Server Page into the Database as a Stored Procedure
Page Directive

My impression is that Oracle seems to be moving away from loadpsp towards
PHP, although mod_plsql still seems to have a significant future.

Configuration for the mod_plsql is in the Application Server
documentation. For 10g (which I HIGHLY recommend) the mod_plsql user's
guide is at http://download-west.oracle.com/docs/cd/B14099_03/web.htm

/FGB

[Frank van Bortel]

cynthih@yahoo.com wrote: I was recently asked to resurrect an Oracle project shelved several years ago. I know almost nothing about Oracle. So, I barely know where to start. There is a windows application that connects to an Oracle server via the Internet, and I was told that the "oracle code was developed against Oracle 8 and makes use of their web portal stuff" and it uses PL/SQL. The oracle code consists of a bunch of .sql and .psp files. I was told that if I loaded the oracle code into oracle, it should work. I started by downloading Oracle9i Database and installing it on XP Pro. But, now I think I need the Application Server. Do I need the Application Server? Do I need the Database? How do I get the code into Oracle? Will there be a problem with using code for Oracle 8 with a newer version? Would there be any difference/problem using Linux or Solaris instead of XP Pro if the code was originally developed under Windows? Any help is appreciated. Thank you.

I do have to disagree with two fellow-posters here.

The Apache by Oracle, as well as the pl/sql module have been
standard install with the database since 8.0.
10g may have changed that, and you may need the Companion CD for
Apache by Oracle, but certainly you do *not* need iAS (the
Application Server)
--
Regards,
Frank van Bortel