Building Air Castles
Quest for better software, faster
Labels
.net
(1)
*nix
(1)
administration
(1)
Android
(2)
Axis2
(2)
best practice
(5)
big-data
(1)
business-analysis
(1)
code re-use
(1)
continuous-integration
(1)
Cordova-PhoneGap
(1)
database
(2)
defect
(1)
design
(3)
Eclipse
(7)
education
(1)
groovy
(2)
https
(2)
Hudson
(4)
Java
(1)
JAX-RS
(2)
Jersey
(3)
Jetty
(1)
localization
(1)
m2eclipse
(2)
MapForce
(1)
Maven
(12)
MySQL
(1)
Nexus
(4)
notes
(4)
OO
(1)
Oracle
(4)
performance
(1)
Perl
(1)
PL/SQL
(1)
podcast
(1)
PostgreSQL
(1)
requirement
(1)
scripting
(1)
serialization
(1)
shell
(1)
SoapUI
(1)
SQL
(1)
SSH
(2)
stored procedure
(1)
STS
(2)
Subclipse
(1)
Subversion
(3)
TOAD
(3)
Tomcat
(4)
UML
(2)
unit-testing
(2)
WAMP
(1)
WAS
(3)
Windows
(3)
WP8
(2)
WTP
(2)
XML
(4)
XSLT
(1)
Showing posts with label
stored procedure
.
Show all posts
Showing posts with label
stored procedure
.
Show all posts
Friday, February 4, 2011
Executing Oracle stored procedure with TOAD
In this example, the stored procedure returns a ref_cursor based on some input parameters. In a TOAD Editor window, have something like this:
select MySchema.MyPackage.MyStoredProcedure('param1', 'param2') from dual
and click on
.
You will get results as a 1 by 1 grid, a concatenation of all the results, created by TOAD.
Older Posts
Home
Subscribe to:
Comments (Atom)