Skip to Content
0
Former Member
Aug 13, 2015 at 06:06 AM

Crystal Reports 2013 with Oracle Native Client can't call SP

70 Views

Hello,

May i know if it is possible to call Oracle SP from Crystal Reports thru Oracle Native Client?

I try the following example which wont works, but it works fine with simple SQL statement like "select * from sampletable"

execute upkg_sample.sp_sample( '{?in_id}', '{?in_sys_id}',

'{?in_abbr}', '{?in_name}',

'{?in_hic}', '{?in_brc}',

'{?in_addr}', '{?in_active}',

'{?in_order_by_field}', '{?in_display_order}', '0','1' )

OR

exec user.upkg_sample.sp_sample( '{?in_id}', '{?in_sys_id}',

'{?in_abbr}', '{?in_name}',

'{?in_hic}', '{?in_brc}',

'{?in_addr}', '{?in_active}',

'{?in_order_by_field}', '{?in_display_order}', '0','1' )

Are there any method to call SP from CR with Native Client?

thank you.