tool for stored proc. (written in oracle/sql) execution?

Hi,

Can somebody suggest a tool with which I can compare the result obtained
after execution of stored procedure in oracle and sql?
Basically, I have migrated my stored procedure written in sql 2000 to
oracle. Now I want to check whether result obtained after execution of
oracle SP will be remain same as that of the sql stored procedure execution
result.

Any help will be appreciated

Thanks in Advanced,
Deepak




.

Relevant Pages

  • Re: Stored Procedures vs DTS vs Jobs
    ... A stored procedure is complied code meaning that SQL Server has already ... > execution time, ...
    (microsoft.public.sqlserver.dts)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: I cant schedule more than one jobs with Oracle Scheduler
    ... scheduled jobs instead of raw sql commands if the commands tend to be ... Oracle doesn't force you to do it in some particular ... The problem is that SQL VARCHAR2 type ... wrapping it into a stored procedure will remove ...
    (comp.databases.oracle.server)
  • Re: EXEC syntax for SP which returns row set
    ... >>> Oracle experts, none of whom seem to know. ... >> SQL> create or replace package returncur is ... > I don't know why you are supplying the above example. ... to illustrate HOW you'd call a stored procedure and return ...
    (comp.databases.oracle.server)
  • Re: SQL DBA Consultants
    ... When I mentioned "loops" it's just ... > because that's the way it appears if you trace the execution. ... > SQL statement is constructed. ... >> sql within a stored procedure I am guessing that you are building and ...
    (microsoft.public.sqlserver.programming)