webprogrammingwithplsql-資料下載頁(yè)
【導(dǎo)讀】HTTP. PL/SQLWebToolkit. ParameterPassing. HTMLForms. PL/SQLServerPages. 3-tier:client,mod_plsqlinOAS. PL/SQLWebToolkit. browser.tomod_plsql.application.location/[[!][schema.][package.]proc_. name[?query_string]]. Example:. GET,POST,HEADmethods. l_uservarchar2(30);(1,'SimpleExample');('Today''sdateis:'||to_char(sysdate,'DD/MM/YYYY'));('Today''sdayis:'||to_char(sysdate,'DAY'));('YourOracleUSERIDis'||l_user);('RajSunderraman');--('');(SQLERRM);END;Uploadtheprocedure?simple?tothe. Procedurecreated.Noerrors.Runprocedure:. etc.END;Morehtpfunctions:. –Applet:,…–List:,,…–Form:,…–Table:,,…–Image:,etc.–Formatting:,,,…–Frame:,…ignore_moreboolean;ignore_more:=('emp',
【正文】 seful functions: : Returns the prefix of the URL pointing to PL/SQL procedure Example: ? Use in PL/SQL web program as: ( path || ?start_session?)。 CSC8711 Disadvantages of Web Toolkit ? PL/SQL Web Toolkit (htp, htf) generates HTML code form PL/SQL programs. ? Generating nice web pages is difficult, you cannot author PL/SQL programs in Frontpage. ? Solution is PSP (next) CSC8711 PL/SQL Server Pages (PSP) ? Author web pages using scriptfriendly HTML authoring tools. ? Drop in PL/SQL code in web pages. ? In short: – Web Toolkit: generate HTML from PL/SQL – PSP: embedded PL/SQL within HTML CSC8711 PL/SQL Server Pages (PSP) ? Same script tag syntax as JSP, also similar to ASP ? PSP files should have .psp extension ? Can be as simple as an HTML page (no PL/SQL script) ? Specifying the scripting language %@ page language=PL/SQL % CSC8711 PL/SQL Server Pages (PSP) ? Parameter passing %@ plsql parameter=varname % ? Returned document type %@ page contentType=MIMEtype % Such as text/xml, text/plain, image/jpeg ? Stored procedure name %@ page procedure=proame % CSC8711 PL/SQL Server Pages (PSP) ? Loading psp document to Oracle loadpsp [ replace ] user username/password[@connect_string] [ include_file_name ... ] [ error_file_name ] psp_file_name ...
鄂ICP備17016276號(hào)-1