Crystal Report and Oracle Function

[bubu2006]

I have created one function in Oracle10g. Now I want to use that in Crystal Report. That function has ref cursor. Can I use that without Oracle package?

Any one has any clue?

 

[synapsevampire]

Please post your Crystal version. You post your database version but not Crystal???

Do you mean you wish to use an Oracle function as the datasource for a Crystal Report?

You might be able to use a Command Object to do so, though an SP would certainly work, again, depends on your software.

Please always post your software version with any post about any software product.

-k

 

[bubu2006]

I am using Oracle 10g and Crystal Report 10.5. I have used user defined Oracle function in Crystal command and that worked fine. Now I have a function where I have ref cursor. Do I need a package or I can use it directly as a data source?

 

[synapsevampire]

What happened when you tried it?

I've used cursors in command objects directly in SQL Server(I know, shocking, but it worked), try calling your function in the command, otherwise you might need an SP and package.

-k