Welcome to dynamicpsp.com, home of Dynamic PSP™ and Objective PSP™ technologies for Oracle 11g, Oracle 10g, 8i/9i-based Internet development.

Blog on Russian is here. On English coming soon.
If you have any question do not hesitate, ask me.

December 29, 2006: The task: Uploading data from .dbf file to Oracle, by using PL/SQL convert file from *.dbf file to *.csv file and use the result *.csv file for Oracle external table.
Solution: Create Java class to convert file.
PL/SQL:
set serverout on
declare
Path varchar2(1000) := '/temp/'; -- directory with perms
DFBFile varchar2(1000) := 'DFBFile.dbf';
CSVFile varchar2(1000) := 'CSVFile.csv';
Fine varchar2(1000);
begin
Fine :=
nn$dbf2csv.dbf2csv(Path||DFBFile, Path||CSVFile, ';');
dbms_output.put_line(substr(Fine,1,255));
end;
/
Result: Done.
Will be created 'CSVFile.csv' file inside '/temp/' dir.
Fine will return a sql script for create external table
Install:
1. loadjava -user user/user@ora -grant public -resolve dbf2csv.jar
2. sqlplus user/user@ora @dbf2csv.sql

Note: run dbms_java.grant_permission for '/temp/'

April 11, 2006: DPSP Version 2.5.1 build for Oracle Database 10g/9i and Oracle Express Edition (Oracle Database XE).
* Oracle XE non Java version file - create_xe.sql
* Oracle 10g/9i with Java version file - create_all.sql
* Oracle 8i with Java version file - create_all.sql
* Servlet for Tomcat 5.5 with source code included
* JSP access for Tomcat 5.5 with source code included
* Admin Unit's with source code included
* Added Unit's function whoCalledMe return number of unit caller
* Added Unit's function getUnitAttr(id in varchar2, attr in varchar2 default null) return varchar2
* Added Unit's attributes COMMENT, ANNOUNCEMENT, LOCAL_PATH, PARAMS
----------------------------------------------------------------------
How to Install Dynamic PSP, Version 2.5.1 - Oracle XE/10g/9i
----------------------------------------------------------------------
Oracle XE
> sqlplus "sys/...@... as sysdba" @create_xe.sql
Oracle 8/9/10g
> sqlplus "sys/...@... as sysdba" @create_all.sql or
> sqlplus "sys/...@... as sysdba" @create_java.sql

----------------------------------------------------------------------
Please Read Section "4. IMPORTANT!" in Readme.txt
----------------------------------------------------------------------

Also includes Dynamic PSP core, unlimited units license, JOPA and licenses for all released DPSP add-ons, unit sources and more.

April 10, 2006: The task: Uploading data from .xls file to Oracle, by using PL/SQL convert file from *.xls file to *.csv file and use the result *.csv file for Oracle external table.
Solution: Create Java class to convert file.
PL/SQL:
set serverout on
declare
Path varchar2(1000) := '/temp/'; -- directory with perms
Fname varchar2(1000) := 'ExcelFile.xls';
Fine varchar2(1000);
begin
Fine := nn$gocsv.ConvertCSV(Path,Fname,';');
dbms_output.put_line(substr(Fine,1,255));
end;
/
Result: Done.
Will be created 'ExcelFile.xls.csv' file inside '/temp/' dir.
Note: run dbms_java.grant_permission for '/temp/'

February 15, 2006: DPSP Version 2.4.5 build for Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer.

DPSP Version 2.4.5
* Oracle 10g/XE tested
* Apache2 and Tomcat 5.5 tested
* JOPA GATEWAY SERVLET included
* Site-Ready UNITs with visial editor

Also includes Dynamic PSP core, unlimited units license, JOPA and licenses for all released DPSP add-ons, unit sources and more.

September 13, 2005: Apache Tomcat 5.x.x is the JServ offspring fully conformant to the J2EE 1.3 and later specifications. Deployment to the Tomcat server is very simple:Copy the jopa.war file to the {CATALINA_HOME}/webapps directory or upload it through the Tomcat management interface. The Tomcat server will detect the new WAR and deploy it automatically. However, before the JOPA Servlet can be used, you need to edit the WEB-INF/web.xml file in the {CATALINA_HOME}/webapps/jopa directory, where the servlet will be automatically deployed, and set cfgfile initialization parameter to contain correct full path to the JOPA configuration file. Save the web.xml file and the Servlet will be fully functional. more info

• Oracle JDeveloper 10g (Version 10.1.2, build 1811)
• Oracle JDeveloper 10g (Version 9.0.5.2, build 1618)
• Oracle JDeveloper 10g (Version 9.0.5.1, build 1605)
• Oracle9i JDeveloper (Version 9.0.4.1.1, build 1436)
• Oracle9i JDeveloper Maintenance Release (Version 9.0.3.4, build 1247)

April 25, 2005: Dynamic PSP Version 2.4.4 Enterprise Edition includes Dynamic PSP core, unlimited units license, JOPA Runtime and licenses for all released DPSP add-ons, plus at least one license for all new add-ons which will be released within 1 year of purchase date.
* Fixed UTF-8 support in DPSP Kernel
* Fixed EditorMainForm (build in Unit Editor) to save long files. Now limit is 200000 bytes per unit.
* Added new DPSP Example 5: Upload File
* Added new DPSP Example 6: Download File
* Added ErrorDocument-401 support
* Added ErrorDocument-403 support
* Added ErrorDocument-404 support

Installation instructions is here

March 14, 2005: You may deploy the servlet manually or automatically through the server management and deployment tools. To deploy the servlet manually, you need to copy the supplied JAR or WAR file (jopa.jar or jopa.war) to the application server and add it to the servlets container class path. Deploying servlets differs from container to container, so you need to consult your container's documentation for instructions on servlet deployment. This chapter will describe in detail how to deploy the servlet on Apache JServ and Oracle OC4J. Other containers may require different deployment procedures, though since the servlet is provided in standard WAR archive, there should be no problems deploying it to any J2EE 1.3 compatible container. more info

January 24, 2005: Dynamic PSP API allows you to create a simple JSP code to access any DPSP unit. Do not lose your time to write complicated code for JSP just use this simple example to access any DPSP page. By using DPSP you can write any PL/SQL code and run it by using just one JSP page.

January 24, 2005: You are developing a web application which is based on an Oracle® database. You want to use PSP (PL/SQL™ Server Pages) technology along with other server-side scripting technologies, like JSP, to build the application and leverage the power of PL/SQL where appropriate. However, your developers are working remotely and you don’t want to open direct access to the database for them or anyone else outside your local network. Dynamic PSP™ seems to be natural choice for these requirements, but your developers are unfamiliar with its web-based development interface or find it too simple and limited compared to web development tools like Macromedia DreamWeaver® or Microsoft® FrontPage®. You need some way to provide them with access to the Dynamic PSP unit repository, the database and the web server without putting the database at risk by opening it to the whole world and opening too many alternate access paths to the web server file system. You also want your Dynamic PSP application to process requests as quickly as possible with minimal overhead introduced by the middleware. more info

December 29, 2004: Dynamic PSP Version 2.4.2 Enterprise Edition includes Dynamic PSP core, unlimited units license and licenses for all released DPSP add-ons, plus at least one license for all new add-ons which will be released within 1 year of purchase date.
* Added Impex - Dynamic PSP(tm) Import/Export Utility
* Added NLP (Natural Language Processing) - is an add-on to Dynamic PSPT (DPSPT). NLP allows teaching your DPSP units to speak different languages.
* Added Name-Tree Service (NTS) is a Dynamic PSP add-on module, which provides developers and content managers with familiar and comfortable file system-like resource naming subsystem for managing Dynamic PSP units and static content, like images and documents, over the web. When installed on Dynamic PSP system, NTS provides name resolution layer for DPSP Kernel and adds web interfaces for managing the tree structure and resources of the site. NTS is transparent to the end users and developers accessing the DPSP site. In addition, NTS provides a framework API that allows developers to extend basic capabilities of the system by adding new resource types and mechanisms for accessing and processing them. NTS is also a vital component for JOPA Gateway servlets WebDAV support. JOPA servlet (available by request) relies on NTS for building the virtual file system and managing resources (Dynamic PSP units and files) of a DPSP-powered site.
Installation instructions is here

December 7, 2004: By clicking on that link whole our site will be displayed throw JOPA™ Gateway Servlet - an alternative to mod_plsql gateway, the JOPA Gateway Servlet supports latest IETF standards and is designed to overcome limitations and flaws in mod_plsql.
Look here how to use DreamWeaver™ MX 2004 and Dynamic PSP for Oracle !

Dynamic PSP™ for Macromedia® DreamWeaver™ is here.
JOPA™User Guide is here.

December 5, 2004: Here you can try to edit any screen of our site and looked at your changes online. Sure it is will not related to real data, because this is only a demo.
By clicking on that link you can try to edit our home page and look at your results online.

November 15, 2004: "MAZService" as Russian's company, changed website by using our technology, which provides fastest and easiest solution for building sophisticated interactive and responsive Web based applications. This is totally redesigned information system based on Dynamic PSP.

May 14, 2004: Using our "Easy Reports" from Dynamic PSP you can publish Reports in three easy steps. Our "Easy Reports" is fully supports sorting by columns names !
Click Here to view a real example online.

April 19, 2004: Look at our "Getting Started" and you will see how easy to manage sites within JOPA™ and Dynamic PSP.
And you can test it online right away - just download connection for DreamWeaver to our Demo site. Do not forget to install Dynamic PSP support Site Extension for Macromedia Products.

Dynamic PSP technology provides fastest and easiest solution for building sophisticated interactive and responsive Web based applications using Oracle RDBMS. Combining simplicity and power it gives developers really rapid way for creating high-performance business applications for intranets and Internet. Based on Oracle 11g, Oracle 10g, 8i/9i and its native programming language, PL/SQL, Dynamic PSP technology allows developers to use all capabilities of this most powerful database for rapid Internet/intranet applications development right from their browsers.

Main features:

• Browser-based development environment
• No intermediate steps like compilation and uploading files are required
• Changes in applications can be done fast and easily
• No additional software except Oracle Database and web browser is required
• Tight integration with Oracle Database
• Platform independence (runs anywhere Oracle does)
• Easy to learn and use

More about features and benefits...

Click here for more info and news...