Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

ANYDATASET TYPE, 5 of 11


SET* Member Procedures

This procedure sets the current data value.

The type of the current data value depends on the MODE with which we are constructing (depending on how we have invoked the PieceWise() call). The type of the current data should be the type of the AnyDataSet if PieceWise() has NOT been called. The type should be the type of the attribute at the current position if PieceWise() has been called.

Syntax

MEMBER PROCEDURE SetNumber(
   self              IN OUT NOCOPY AnyDataSet,
   num               IN NUMBER,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetDate(
   self              IN OUT NOCOPY AnyDataSet,
   dat               IN DATE,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetChar(
   self              IN OUT NOCOPY AnyDataSet,
   c                 IN CHAR,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetVarchar(
   self              IN OUT NOCOPY AnyDataSet,
   c                 IN VARCHAR,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetVarchar2(
   self              IN OUT NOCOPY AnyDataSet,
   c                 IN VARCHAR2,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetRaw(
   self              IN OUT NOCOPY AnyDataSet,
   r                 IN RAW,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetBlob(
   self              IN OUT NOCOPY AnyDataSet,
   b                 IN BLOB,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetClob(
   self              IN OUT NOCOPY AnyDataSet,
   c                 IN CLOB,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetBfile(
   self              IN OUT NOCOPY AnyDataSet,
   b                 IN BFILE,
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetObject(
   self              IN OUT NOCOPY AnyDataSet,
   obj               IN "<object_type>", 
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetRef(
   self              IN OUT NOCOPY AnyDataSet,
   rf                IN REF "<object_type>",
   last_elem boolean DEFAULT FALSE);
MEMBER PROCEDURE SetCollection(
   self              IN OUT NOCOPY AnyDataSet,
   col               IN "<collection_type>",
   last_elem boolean DEFAULT FALSE);

Parameters

Table 86-5 SET* Procedure Parameters
Parameter  Description 

self 

The AnyDataSet being accessed. 

num 

The number, etc., that is to be set. 

last_elem 

Relevant only if PieceWise() has been already called (for a collection). Set to TRUE if it is the last element of the collection, FALSE otherwise. 

Exceptions


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback