Oracle8i interMedia
Using Oracle8i interMedia with the Web
Release 8.1.5.2

A77033-01

Contents

Prev

Index

A  B  C  D  E  F  G  H  I  K  L  M  N  O  P  Q  R  S  T  U  V  W  Z 


Symbols

~mediaget request mode, 3-13, 4-27

A

adding database agents, 2-5
admin_password configuration parameter, 2-7
admin_user configuration parameter, 2-7
administering Web Agent, 2-2
administration section
configuration file, 2-6
agent names, 2-9
agent_list_password configuration parameter, 2-7
agent_list_user configuration parameter, 2-7, 3-2
agents
database, 2-8
Web, 1-1, 1-4, 2-1, 3-1
Apache Web Server, 1-4
configuration file and, 2-2
appmediaput request mode, 3-13, 4-27
attaching to databases, 3-2
attributes
setting, 3-7, 4-2, 4-3, 4-5, 4-9, 4-10
audio data, 1-3
streaming, 1-3
authentication, 2-15
authentication_realm_name configuration parameter, 2-10, 2-16
authorized_request_class configuration parameter, 2-9
authorized_sql_procedures configuration parameter, 2-11, 3-13
authorized_sql_statements configuration parameter, 2-10

B

BFILEs, 1-3
directory specification, 4-12
retrieving, 4-25
source location and, 4-12
source name and, 4-12
source type and, 4-12
specifying locator as parameter, 4-7, 4-15
storing, 4-11
binary large objects (BLOBs)
See BLOBs
BLOBs, 1-2
form for storing, 4-3
retrieving objects from, 4-16
specifying LOB locator as parameter, 4-7, 4-8, 4-15
storing objects in, 4-9

C

cache
controlling, 4-7
PL/SQL procedures and, 4-6
retrieving objects, 3-4, 3-7, 4-20
CACHE_STATUS function, 4-20
Cache-Control HTTP request header field, 4-7
capturing data
from devices, 3-9, 3-10
catalog tables
installing, 3-1
character large objects (CLOBs)
See CLOBs
characters
HTTP reserved, 3-14
Clipboard
Oracle8i interMedia, 1-1, 1-3
invoking, 3-2
using, 3-1
clipboard request class, 2-9, 2-14
database agent and, 2-10
clipboard_user configuration parameter, 2-11
CLOBs, 1-2
specifying LOB locator as parameter, 4-7, 4-8, 4-15
Code Wizard
using, 3-5
configuration files
administration section, 2-6
Apache Web Server and, 2-2
creating, 2-1
database agent section, 2-8
example, 2-2
general section, 2-6
Web Agent section, 2-7
configuration parameters
admin_password, 2-7
admin_user, 2-7
agent name, 2-9
agent_list_password, 2-7
agent_list_user, 2-7
authentication_realm_name, 2-10
authorized_request_class, 2-9
authorized_sql_procedures, 2-11
authorized_sql_statements, 2-10
clipboard_user, 2-11
database_password, 2-9
database_user, 2-9
display_name, 2-10
entry_point, 2-7
free_temp_lobs, 2-11
iis_extension_url, 2-6
image_name, 2-7
retrieve_database_agent, 2-10
service, 2-9
temp_file_dir, 2-6
upload_database_agent, 2-10
virtual_path, 2-7
configuring database agents, 2-8
configuring Oracle8i interMedia Web Agent, 2-1
connecting to databases, 3-2
content
returning, 4-17
content length
returning, 4-19
content types
returning, 4-19
controlling caching, 4-7
copying data
from Windows NT Clipboard, 3-9, 3-10
creating database agents, 2-5
creating PL/SQL procedures, 4-5

D

data types
dates
converting, 4-20
database agents, 2-2
configuration entries, 2-8, 2-15
creating, 2-5
in URL format, 3-13
names, 2-9
request classes and, 2-13, 2-14
database_password configuration parameter, 2-9
database_user configuration parameter, 2-9
databases
connecting to, 3-2
security, 2-12
service names for, 2-9
dates
converting, 4-20
modification, 4-17, 4-19, 4-20
setting time zone, 4-21
DBMS_LOB package, 4-19
DBMS_SERVER_GMTDIFF constant, 4-21
DBMS_SERVER_TIMEZONE constant, 4-21
debugging requests, 4-27
DECODE function, 4-19
deleting content, 4-9
deleting multimedia objects, 4-19
directory
BFILEs and, 4-12
display name, 2-10
display_name configuration parameter, 2-10
.dll
entry point, 2-7
domain name, 3-13
drag modes, 3-11
dynamic link library (.dll)
entry point, 2-7

E

editing multimedia data, 3-15
editing software
invoking, 3-15
Embed drag mode, 3-11
EMPTY_BLOB function, 4-9, 4-19
EMPTY_CLOB function, 4-19
encoding type
forms and, 4-2
entry_point configuration parameter, 2-7
error files, 2-16, 2-17
error handling, 4-22
error messages, 2-16, A-1
errors
debugging, 4-27
handling
redirection and, 4-26
retrieving data, 4-24
external files
See BFILEs

F

file-based large objects
See BFILEs
files
storing data from, 3-9
updating data from, 3-10
forms
creating, 4-2
POST method and, 4-2
storing data and, 4-1, 4-3
free_temp_lobs configuration parameter, 2-11
freeing temporary LOBs, 2-11
functions
CACHE_STATUS, 4-20
DECODE, 4-19
EMPTY_BLOB, 4-9, 4-19
EMPTY_CLOB, 4-19
GETLENGTH, 4-19
HTTP_TO_ORACLE_DATE, 4-20
ORACLE_TO_HTTP_DATE, 4-20

G

general section of configuration files, 2-6
GetContent method, 4-9, 4-16
GetContentLength method, 4-16
GETLENGTH function, 4-19
GetMimeType method, 4-16, 4-17
GetUpdateTime method, 4-16, 4-17
Greenwich Mean Time (GMT), 4-21

H

handling errors, 4-22
redirection and, 4-26
HTML authoring tools, 1-3
HTTP Basic Authentication Scheme, 2-15
HTTP header fields
Cache-Control, 4-7
If-Modified-Since, 4-20
Last-Modified, 4-7, 4-21
parameters, 4-8
HTTP reserved characters, 3-14
HTTP status codes, 4-22
cache and, 4-21
HTTP_CACHE_CONTROL parameter, 4-7
HTTP_LAST_MODIFIED parameter, 4-7
HTTP_REDIRECT parameter, 4-7, 4-8, 4-24, 4-25
HTTP_STATUS parameter, 4-6, 4-8
HTTP_TO_ORACLE_DATE function, 4-20

I

If-Modified-Since HTTP request header, 4-20
iis_extension_url configuration parameter, 2-6
image data, 1-3
image editing software
invoking, 3-15
image_name configuration parameter, 2-7
input parameters, 4-7, 4-8
inserting rows, 3-8
intermedia keyword, 3-13
internet
fetching data from, 3-9, 3-10
invoking Clipboard, 3-2

K

keywords
intermedia, 3-13

L

Last-Modified HTTP response header, 4-21
length
content, 4-16, 4-19
specifying as parameter, 4-6
returning, 4-17
Link drag mode, 3-11
logging into Clipboard, 3-2

M

mediaget request mode, 3-13, 3-14
PL/SQL procedures and, 4-15
mediaput request mode, 3-13, 4-2, 4-26
PL/SQL procedures and, 4-8
messages
error, 2-16, A-1
methods
GetContent, 4-9, 4-16
GetContentLength, 4-16
GetMimeType, 4-16, 4-17
GetUpdateTime, 4-16
SetMimeType, 4-9
SetProperties, 4-10
Microsoft Internet Information Server, 1-4
configuration parameter for, 2-6
MIME types
returning, 4-16, 4-17, 4-19
setting, 4-9
specifying as parameter, 4-6, 4-8, 4-15
modification date
of multimedia objects, 3-4, 3-7, 4-20
multimedia data, 1-2, 1-3
editing, 3-15
retrieving, 3-11, 4-15
cache and, 4-20
storing, 3-8, 4-1, 4-26
updating, 3-10, 4-8

N

Navigator Tree, 3-2
Netscape Enterprise Server, 1-4
Netscape FastTrack Server, 1-4

O

object types
modification date, 3-4
ORDAudio, 1-2, 1-3, 3-4
ORDImage, 1-2, 1-3, 3-4
ORDImgB, 3-4
ORDVideo, 1-2, 1-3, 3-4
ORDVir, 1-3, 3-4
Object View, 3-2
Online Administration form, 2-2
Apache Web Server and, 2-2
Oracle Application Server, 1-4
temporary LOBs and, 2-11
Oracle Video Server, 1-3
ORACLE_TO_HTTP_DATE function, 4-20
Oracle8i interMedia Clipboard, 1-1, 1-3, 2-10
using, 3-1
Oracle8i interMedia data
See multimedia data
Oracle8i interMedia Web Agent, 1-1, 1-4
configuring, 2-1
image name, 2-7
ord_content variable, 4-2, 4-3
BFILEs and, 4-11
URLs and, 4-11
using, 4-9
ORD_CONTENT_BFILE parameter, 4-7, 4-15
ORD_CONTENT_BLOB parameter, 4-7, 4-15
BFILEs and, 4-11
URLs and, 4-11
using, 4-8, 4-16
ORD_CONTENT_CLOB parameter, 4-7, 4-8, 4-15
ORD_CONTENT_LENGTH parameter, 4-6
using, 4-16
ORD_CONTENT_TYPE parameter, 4-6, 4-8, 4-15
using, 4-16
ORD_CONTENT_VARCHAR2 parameter, 4-7, 4-15
ORD_HTML_REDIRECT parameter, 4-7, 4-8, 4-25
using, 4-25
ord_post_put_call variable, 4-2, 4-3
redirection and, 4-26
ord_post_put_sql variable, 4-2
redirection and, 4-26
ORD_PROCEDURE_PATH parameter, 4-7, 4-8, 4-15
using, 4-9
ord_procedure_path variable, 4-2, 4-3, 4-9
ord_sql variable, 3-14, 4-2
ORDAudio object type, 1-2, 1-3, 3-4
content length and, 4-16
last-modified date and, 4-17
MIME type and, 4-16
returning content, 4-16
ORDImage object type, 1-2, 1-3, 3-4
content length and, 4-16
last-modified date and, 4-17
MIME type and, 4-16
returning content, 4-16
ORDImgB object type
last modification date, 3-4
ORDVideo object type, 1-2, 1-3, 3-4
content length and, 4-16
last-modified date and, 4-17
MIME type and, 4-16
returning content, 4-16
ORDVir object type, 1-3, 3-4
ORDWEBUTL package, 3-1, 4-20
output parameters, 4-6

P

packages
DBMS_LOB, 4-19
ORDWEBUTL, 4-20
PL/SQL, 2-11, 3-13
parameters
See also configuration parameters
HTTP_CACHE_CONTROL, 4-7
HTTP_LAST_MODIFIED, 4-7
HTTP_REDIRECT, 4-7, 4-24, 4-25
HTTP_STATUS, 4-6
input, 4-7
ORD_CONTENT_BFILE, 4-7
ORD_CONTENT_BLOB, 4-7, 4-16
ORD_CONTENT_CLOB, 4-7
ORD_CONTENT_LENGTH, 4-6, 4-16
ORD_CONTENT_TYPE, 4-6, 4-16
ORD_CONTENT_VARCHAR2, 4-7
ORD_HTML_REDIRECT, 4-7, 4-8, 4-25
ORD_PROCEDURE_PATH, 4-7, 4-8, 4-9, 4-15
output, 4-6
PL/SQL procedures, 4-6, 4-7
input, 4-8
passwords
in configuration entries, 2-7, 2-9, 2-15
specified in client, 2-15
path information
in URL format, 3-14
PL/SQL packages, 2-11, 3-13
DBMS_LOB, 4-19
ORDWEBUTL, 4-20
PL/SQL procedures
authorized, 2-11, 2-12
cache and, 4-6
creating, 3-5, 4-5
in forms, 4-2
in URL format, 3-13
modifying, 4-6
multimedia objects
setting attributes, 4-2, 4-3, 4-5
post-processing, 4-2, 4-3
security and, 2-12
storing data and, 4-3
supported parameters, 4-6
POST data variables
as parameters, 4-8
POST method, 4-2
procedure paths, 4-2, 4-3
procedures
See also PL/SQL procedures
authorized, 2-11, 2-12
in URL format, 3-13

Q

queries
tables and, 3-15
query string variables
as parameters, 4-8

R

realm name, 2-10, 2-16
redirecting output, 4-24, 4-25
handling errors, 4-26
storing data and, 4-25
to URL, 4-25
request classes, 2-9
clipboard, 2-14
retrieve, 2-13
upload, 2-13
request header fields
Cache-Control, 4-7
If-Modified-Since, 4-20
parameters, 4-8
request modes
~mediaget, 4-27
appmediaput, 4-27
in URL format, 3-13
mediaget, 3-14
mediaput, 4-2, 4-26
requests
debugging, 4-27
reserved characters
in URL, 3-14
response header fields
Last-Modified, 4-21
result sets
refining, 3-15
sorting, 3-15
retrieve request class, 2-9, 2-13
retrieve_database_agent configuration parameter, 2-10
retrieving multimedia data, 2-10, 3-11
cache and, 4-20
errors, 4-24
PL/SQL procedures for, 4-15
status codes, 4-24
returning content, 4-17
returning length, 4-17
returning MIME type, 4-17
rows
storing, 3-8

S

security, 2-12
request classes and, 2-13, 2-14
SQL statement types and, 2-12
user names and, 2-15
servers
Web, 1-4
service configuration parameter, 2-9
service names, 2-9
SetMimeType method, 4-9
SetProperties method, 4-10, 4-13
URLs and, 4-13
setting attributes, 3-7, 4-2, 4-3, 4-5, 4-9, 4-10
setting MIME type, 4-9
setting objects to empty, 4-9
sorting results, 3-15
source location attribute
BFILEs and, 4-12
URLs and, 4-13
source name attribute
BFILEs and, 4-12
URLs and, 4-13
source type attribute
BFILEs and, 4-12
URLs and, 4-13
SQL statement types, 2-10
authorized, 2-12
SQL statements
redirection and, 4-26
storing data and, 4-2
URLs and, 3-14
SQL*Net
service names, 2-9
status codes, 4-22
retrieving data and, 4-24
storing multimedia data, 2-10, 3-8, 4-26
forms and, 4-1
from Web, 4-1
PL/SQL procedures for, 4-8
redirection and, 4-25
storing rows, 3-8
streaming data
audio and video, 1-3

T

Table View, 3-2
tables
querying, 3-15
sorting results, 3-15
temp_file_dir configuration parameter, 2-6
temporary LOBs
freeing, 2-11
time zones
setting, 4-21

U

universal resource locators (URLs)
See URLs
updating multimedia data, 3-10
deleting object before, 4-9
PL/SQL procedures for, 4-8
upload request class, 2-9, 2-13
upload_database_agent configuration parameter, 2-10
URLs, 1-3
fetching data with, 3-9, 3-10
format, 3-12, 4-2
redirecting output to, 4-24, 4-25
retrieving data in, 4-25
source location attribute and, 4-13
source name attribute and, 4-13
source type attribute and, 4-13
SQL statements in, 3-14
storing objects as, 4-11
user names
configuration entries and, 2-7, 2-9, 2-11, 2-15, 3-2
in configuration files, 2-7
specified in client, 2-15

V

variables
ord_content, 4-2, 4-3, 4-9
ord_post_put_call, 4-2, 4-3
redirection and, 4-26
ord_post_put_sql, 4-2
redirection and, 4-26
ord_procedure_path, 4-2, 4-3, 4-9
ord_sql, 3-14, 4-2
POST data, 4-8
query string, 4-8
video data, 1-3
streaming, 1-3
VIR data
See ORDVir object type
virtual_path configuration parameter
in administration section, 2-7
in Web Agent section, 2-7
Visual Information Retrieval (VIR) data
See ORDVir object type

W

Web Agents
Oracle8i interMedia, 1-1, 1-4
configuring, 2-1
using, 3-1
section of configuration files, 2-7
Web authoring tools, 1-3
Web servers, 1-4
time zones and, 4-21
Windows NT Clipboard
copying from, 3-9, 3-10
wizards
code, 3-5
wsc.cfg configuration file, 2-1
wsclstch.err file, 2-17

Z

zones
time, 4-21

Prev
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Contents