Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

28-26.

Given what you know about how procedures are called from the Web, what calling notation (positional or named) do you think the PL/SQL gateway uses to actually perform the call? Discuss the implications the calling format has on your web development effort.

28-27.

Under what circumstances can you call a procedure from the Web using just its name and parameters (i.e., when can you omit the server, port, and virtual schema mappings)?

28-28.

A developer has written the following program:

PROCEDURE val_test (i_val in number default 0) IS
 BEGIN
    HTP.PRINT('The value is: ' || i_val );
EXCEPTION
   WHEN OTHERS THEN
      HTP.PRINT ('Invalid number');
END;

What happens when the following hyperlink is used to call the procedure?

http://myserver/virtual_schema_mapping/val_test?i_val=four

28-29.

Discuss three ways to maintain state in a PL/SQL web application.

28-30.

A consulting company is developing a simple system to help its employees prepare for visits to client sites. The basic idea is that each consultant gets an online schedule of all the clients they are going to see. The schedule also contains a hyperlink to each company’s home page so that the consultant can easily do some basic research.

You have been asked to write an HTML interface based on a view named onsite_schedule. It has the following columns:

Name                            Null?    Type
------------------------------- -------- ----
SALESMAN_ID                              NUMBER
VISIT_DATE                               DATE
COMPANY_NAME                             VARCHAR2(50)
COMPANY_URL                              VARCHAR2(200)

What single PL/SQL toolkit procedure ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page