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 ...

Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.