Jump to content
Changes to the Jaspersoft community edition download ×

crrostab query string


2004 IR Help

Recommended Posts

By: Ljiljana Kozic - ljocko

crrostab query string

2005-11-08 06:07

I have a stored procedure

kadroviIzvPkg.struktura(p1 varchar2, p2 varchar2, p3 date, p4 varchar2, rc sys_refcursor);

 

Here is a peace of jrxml file:

<subDataset name="KADROVISTRUKTURASUB">

<parameter name="UFIRMASUB" class="java.lang.String"></parameter>

<parameter name="UORGJEDSUB" class="java.lang.String"></parameter>

<parameter name="UDATUMSUB" class="java.util.Date"></parameter>

<parameter name="URADNOMESTOSUB" class="java.lang.String"></parameter>

<queryString><![CDATA[{call KADROVIIZVPKG.STRUKTURA($P{UFIRMASUB},$P{UORGJEDSUB},$P{UDATUMSUB},$P{URADNOMESTOSUB})}]]></queryString>

 

<field name="FIRMA" class="java.lang.String"></field>

<field name="FIRMANAZIV" class="java.lang.String"></field>

<field name="ORGJED" class="java.lang.String"></field>

<field name="ORGJEDNAZIV" class="java.lang.String"></field>

<field name="SPREMA" class="java.lang.String"></field>

<field name="SPREMANAZIV" class="java.lang.String"></field>

<field name="POL" class="java.lang.String"> </field>

<field name="STATUS" class="java.lang.String"></field>

<field name="BROJ" class="java.lang.Integer"></field>

</subDataset>

 

 

I got error "wrong number or types of arguments in call to 'STRUKTURA' ORA-06550"

 

When I call this procedure within the main query string everything work just fine

 

Any help

 

 

 

 

By: Lucian Chirita - lucianc

RE: crrostab query string

2005-11-08 08:00

Have you passed values for all the parameters to the sub dataset? This is done inside <datasetRun> by <datasetParameter> or <parametersMapExpression>.

 

Regards,

Lucian

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...