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.