This is a text description of cw18.gif.

This screen capture shows the Compile procedure and review generated source page.

Procedure created successfully: GET_PHOTOS_PHOTO

Click the View button to display the compiled PL/SQL source code in another window. To save the source in a file for editing, select Save As... from your browser's File menu.

Click to display the generated source: View button

Use the following URL format to retrieve media data from the database using the GET_PHOTOS_PHOTO procedure.

http://host:port/DAD-name/get_photos_photo?media_id=key-value

Enter a key value, then click the Test button to test the generated PL/SQL procedure. The media or media player will be displayed in another window.

Key parameter (MEDIA_ID): 1 Test button

Click the Test button to retrieve the image.

The following actions can be selected:

• Done - commits the operation and returns to the Main menu page.

• Back - goes back to the previous page, Step 4: Review selected options.