How to execute/run store procedure from Crystal Command Statement

[toblerone65]

Hello I have a simple store procedure whihc is created to insert records into other table. I like to execute this store procedure from Crystal reports command statement. It does not have any parameters. I use Oracle and Crystal 2008.

When i say exec ABC in command, it throws error. Any help would be great.

best,
Tobey.

 

[Madawc]

I use SQL, so this may not be relevant. But when I want to merge records in some way that's too complex for a single Select, I do an SQL command with several Selects and merge them into a single temporary table. This can be added to the report as if it were a table file.

Does this help?

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[IanWaterman]

You do not need to use a command to run an SP in crystal

Make sure Crystal can see SPs

File->Options-> datebase tab - check Stored Procedures

You will now be able to connect directly to the SP of your choice

Ian