Eclipse Community Forums: Newcomers » Syntax for calling oracle store procedure from dataset

Home » Newcomers » Newcomers » Syntax for calling oracle store procedure from dataset

Syntax for calling oracle store procedure from dataset [message #187791]

Fri, 12 January 2007 11:45

Eclipse User

Originally posted by: TrinhKTran.yahoo.com

I am looking into BIRT 2.2 and I notice that we are able to use the oracle
store procedure in version 2.2 but I am having difficult to use it in the
data set query. Would someone be kindly let me know the syntax for using
the output parameter.

our procedure is using a refcursor. Below is the signature of the Store
Procedure
PROCEDURE p_test (
chflag VARCHAR2 DEFAULT 'C',
P_MIN IN NUMBER,
P_MAX IN NUMBER,
column_in IN VARCHAR2,
pc_test IN OUT Pkg_test.rc_datawindow
);

TYPE rc_datawindow IS REF CURSOR;

Thanks,
Trinh

Re: Syntax for calling oracle store procedure from dataset [message #187800 is a reply to message #187791]

Fri, 12 January 2007 12:22

Eclipse User

Originally posted by: zx.us.ibm.com

Please try the BIRT newsgroups ;)

Cheers,

~ Chris

Previous Topic:	removing "computing additional info" message
Next Topic:	Adding external JDBC JAR to plug-in

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 22 12:44:13 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter