Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Support for CLOBs, BLOBs and REF CURSORS (Read 4666 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Support for CLOBs, BLOBs and REF CURSORS
09.10.05 at 20:46:10
 
Support for CLOB and BLOB columns (Oracle) were built into SQL*XL. Hitherto the data in these columns were not transferred to the spreadsheet. Now they are!
 
Support for REF CURSORS was also built in. A new function was introduced (see the SQL*XL function category in the editor): resultset_from_proc. If you execute select * from resultset_from_proc(...) you can execute a stored procedure in your database and have a recordset returned to you from the stored procedure. This recordset is then processed just like you would process another select statement through SQL*XL.
 
For more information about CLOBS see:
Bytes retrieved from CLOB  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1252325586
Back to top
 
« Last Edit: 11.08.11 at 19:56:04 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Support for CLOBs, BLOBs and REF CURSORS
Reply #1 - 21.10.05 at 16:48:43
 
Please see the following page for more information about the resultset_from_proc command to process the output (REF CURSOR) from a stored procedure:
http://www.oraxcel.com/projects/sqlxl/help/commands/resultset_from_proc.html
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1