Is it possible to call a oracle packaged storedprocedure through

[Former Member]

Is it possible to call a oracle packaged storedprocedure through

Deski?

Also

Receiving error when creating desktop intelligence report while using a

stored procedure that retrieves data from globaltemporary table. Error

message is " Object no longer exists". This same procedure can be

successfully executed from eitherOracle SQL Plus or Crystal Reports.

Any ideas , please help?

[Former Member · Accepted solution]

It is possible to report off Stored Procedures in BusinessObjects Desktop Intelligence XIR2. What you need to do is to configure your Stored Procedure as a data source. If you use parameter please make sure that the default database is set to the database that contains the stored procedure.

e.g. Click the correct DSN for the stored procedure. Click Configure.Click Next until the Change the default database to option appears.Change the default database to the database that contains the stored procedure.

I hope this helps,

Regards,

Tim

[Former Member]

I have only ever been able to get queries to work that actually start with the word "Select". Even if i've had comments in my code in front of the Select, it would generally give me an error message. I'm pretty sure you can't run SP's - at least from the free-hand SQL.