cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Command Object vs Oracle Stored Procedure

Former Member
0 Kudos

...what if any are the differences between the two?

Accepted Solutions (1)

Accepted Solutions (1)

former_member260594
Active Contributor
0 Kudos

Mike,

The main difference is that a command object is stored in the BOE repository as opposed to the database.

Command objects allow users to write their own SQL Query without having to go through the DBA whereas with many customers report writers do not have access or rights to create stored procedures.

Stored procedures may provide more flexibility in the SQL that can be written but for the most part they are both reusable SQL Queries.

Answers (0)