1.

Difference Between Stored Procedure And Macro?

Answer»

Stored PROCEDURE:

  • It does not return rows to the user.
  • It has to use CURSORS to fetch multiple rows
  • It used inout/Out to send values to user
  • It contains comprehensive SPL
  • It is stored in DATABASE or USER PERM
  • A stored procedure ALSO provides output/Input capabilities

MACROS:

  • It returns set of rows to the user.
  • It is stored in DBC PERM space
  • A macro that allows only input values

Stored Procedure:

Macros:


Discussion

No Comment Found

Related InterviewSolutions