Databases Reference
In-Depth Information
dbms lob.createtemporary ( lob loc => l mail blob
, cache => true
);
dbms lob.copy( l mail blob
, l blob
, dbms lob.lobmaxsize
, 1
, dbms lob.instr( lob loc => l blob
, pattern => utl raw.cast to raw(l search)
)
);
-- Add the file as a BLOB attachment to the mail
apex mail.add attachment
( p mail id => l mail id
, p attachment => l mail blob
, p filename => 'feedback export from '||lower(p workspace)||'.sql'
, p mime type => 'application/text'
);
commit;
end;
Wrap Up
Now that you know about the functionality of Team Development, it may become clear that the
planning capacity of Team Development doesn't beat a “real” project management tool, like Microsoft
Project. Even if you add some nice Gantt charts, which are an absolute necessity for any planning tool,
Team Development still lacks too much functionality. Here are a fewof the things you can't do with
Team Development:
•
Add a capacity to a resource (like 40 hours per week).
•
Plan using the given capacity.
•
Add a cost to a resource, so you can plan how much money you have to spend.
•
Monitor how many hours a resource spends, using an interface with a time
reporting application.
•
Add multiple predecessor to To Do's, so you can plan and execute the actions in
the right order and determine the critical path.
Of course, you can build all this in your custom Team Development Enhancements application, but
capacity planning and critical path determination are complex mathematical issues and not easy to
solve. Still, for small projects (up to five people or so), Team Development might be a very convenient—
and inexpensive—tool to use. But when a project starts getting more complex, you have to spend some
money and buy a specialized tool to support your business.
That said, the Feedback feature of Team Development is in itself so powerful—especially when you
add functionality like that shown in the examples—that for Feedback alone you should consider
usingTeam Development. When you're in the test phase of your project in particular, Feedback will
facilitate communication between users and developers. Your application can only benefit from that.
