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.
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.
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.
Subscribe to:
Post Comments (Atom)
Would you show some (as an example) stored procedure code? (Please) ( I am very new to Oracle and TOAD.)
ReplyDelete