Re: testing Package from within TOAD

I've used the TOAD debugger. And the debugger in SQL Navigator. And a host of others. And they are fine for their intended purpose. But SQL*Plus is still the place to be for testing which is what was asked.

Daniel Morgan

No Name wrote:

> TOAD has a really cool debugger that you should learn how to use. No
> scripting involved, just use the help screens and follow the directions.
>
> Louis
>
> damorgan wrote:
>
> > I don't know whether you can, or not, but it is a very bad idea. If you want
> > to test a procedure ... execute it from the SQL*Plus command line.
> >
> > Daniel Morgan
> >
> >
> >
> > Eric Mamet wrote:
> >
> >
> >>I want to use Procedures returning references to cursors from within
> >>ASP or Vbscript environments.
> >>
> >>To make sure everything is fine with the procedure, I'd like to "test"
> >>it manualy from within TOAD.
> >>Can I do that for this sort of procedure?
> >>Could you show me a sample script?
> >>
> >>Regards
> >>
> >>Eric
> >>
> >>See below a procedure example taken from the Microsoft MSDN
> >>PACKAGE curspkg_join AS
> >> TYPE t_cursor IS REF CURSOR ;
> >> Procedure open_join_cursor1 (n_EMPNO IN NUMBER, io_cursor IN OUT
> >>t_cursor);
> >>END curspkg_join;
> >>
> >>PACKAGE BODY curspkg_join AS
> >>Procedure open_join_cursor1 (n_EMPNO IN NUMBER, io_cursor IN OUT
> >>t_cursor)
> >>IS
> >> v_cursor t_cursor;
> >>BEGIN
> >> IF n_EMPNO <> 0
> >> THEN
> >> OPEN v_cursor FOR
> >> SELECT EMP.EMPNO, EMP.ENAME, DEPT.DEPTNO, DEPT.DNAME
> >> FROM EMP, DEPT
> >> WHERE EMP.DEPTNO = DEPT.DEPTNO
> >> AND EMP.EMPNO = n_EMPNO;
> >> ELSE
> >> OPEN v_cursor FOR
> >> SELECT EMP.EMPNO, EMP.ENAME, DEPT.DEPTNO, DEPT.DNAME
> >> FROM EMP, DEPT
> >> WHERE EMP.DEPTNO = DEPT.DEPTNO;
> >> END IF;
> >> io_cursor := v_cursor;
> >>END open_join_cursor1;
> >>END curspkg_join;
> >>
> >
Received on Tue Feb 12 2002 - 22:09:46 CET