21st Century PL/SQL
Your chance to influence the direction of the Oracle PL/SQL language.
Built-in (Supplied) Packages > DBMS_OUTPUT
Most of us use this package, and most of us have a love-hate relationship with it. What should be done to make it easier to use and richer in functionality?
Ideas within DBMS_OUTPUT
| Top Vote Getters | Top Scorers |
|---|---|
March 31, 2005
Add overloadings to DBMS_OUTPUT.PUT_LINE.
DBMS_OUTPUT.PUT_LINE displays to the screen or host environment data from my PL/SQL program. Currently, it only supports displaying of strings (and data that can be implicitly converted to strings).
There are several datatypes that should be supported by this program, including:
* Object types
* Records
* Collections
* Files via a UTL_FILE handle
* XML documents
* CLOBs
Posted by sf at 08:29 AM | Add your thoughts (6)
Sidebar Template
Search Template
Search 21st Century PL/SQL
Actions Template
Actions
Ideas List Template
Browse Categories
- Built-in (Supplied) Packages
- DBMS_LOB
- DBMS_OUTPUT
- New built-in packages
- modplsql
- UTL_FILE
- UTL_MAIL
- Data structures and datatypes
- Built-in Procedures and Functions
- Collections
- adding two collections in runtime
- Dates, timestamps, intervals, etc.
- Numbers
- Object types
- String manipulation
- Exception handling
- exception
- General and Miscellaneous issues
- Loops, conditionals, other control logic
- Performance-related Issues
- Program unit construction and structure
- SQL processing inside PL/SQL
- Bulk processing FORALL and BULK COLLECT
- DML Operations (INSERT, UPDATE, DELETE)
- Dynamic SQL and Dynamic PL/SQL
- Querying data in PL/SQL
- Querying with REF CURSORS (cursor variables)
- Transaction management