PL/Sql procedure execution in Crystal Reports?

[marek16]

Hi all!

We use Oracle Apps 11i, database version Oracle 8.1.7
For selecting certain views, I have to setup organization as an "enviroment" first:

In SQL*Plus it works like this:
a) I need to run script:
SQL> exec dbms_application_info.set_client_info(204)

PL/SQL procedure successfully completed.

b) It is ready to select data:
SQL> select vendor_name
2 from ap_invoices_v
3 where invoice_id = 16217;

VENDOR_NAME
----------------------------------
American Telephone and Telegraph

Question!
How can I run this execution script (exec dbms...) in Crystal Reports???

Marek

 

[synapsevampire]

You can't.

Although you may be able to run this as part of a Stored Procedure from within a report, I'm not sure though.

Here's the dope on Oracle Stored Procedures within CR:

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lyanch]

You can't. Crystal can't handle an Oracle SP calling another SP. You have to duplicate your original SP within the output SP so they are all one.

Lisa