Databases Reference
In-Depth Information
p seq id IN NUMBER,
p attribute number IN NUMBER,
p attribute value IN VARCHAR2
)
IS
v collection VARCHAR2 (40) := 'EMP DEPT';
v number NUMBER;
v date DATE;
v message VARCHAR2 (4000);
BEGIN
IF p seq id IS NOT NULL
THEN
IF p attribute number IN (4, 6, 7, 8)
THEN
v number := TO NUMBER (p attribute value);
ELSIF p attribute number IN (5)
THEN
v date := TO DATE (p attribute value);
END IF;
apex collection.update member attribute
(p collection name => v collection,
p seq => p seq id,
p attr number => p attribute number,
p attr value => p attribute value
);
END IF;
EXCEPTION
WHEN OTHERS
THEN
v message := SQLERRM;
HTP.p (v message);
END update emp coll member;
The JavaScript code shown in Listing 3-12, added to the page HTML header of application page 3,
will call the On-Demand Process and check the return value of that process for errors.
Listing 3-12.
Tabular Form—Collection—Ajax
<script language="JavaScript" type="text/javascript">
function LPad(ContentToSize,PadLength,PadChar)
{
var PaddedString=ContentToSize.toString();
for(i=ContentToSize.length+1;i<=PadLength;i++)
{PaddedString=PadChar+PaddedString;}
return PaddedString;
}
function f update emp coll member(pThis,pRownum,pAttribNo){
var v seq array = 'f02 ' + LPad(pRownum, 4, "0");
var SeqID = $x(v seq array).value;
var get = new htmldb Get(null,$x('pFlowId').value,
