Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Stored Procedures
Stored Procedures [message #168135] Wed, 07 June 2006 10:15 Go to next message
Eclipse UserFriend
Folks,
I need to execute a stored proc that is referenced within a BIRT
rptdesign file. Can anybody either explain how to achieve that or point
me in the direction of any relevant documentation?

I have had no luck calling it this way:

{CALL PROC_WORKSHEET_REPORT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
}


Thank you,
Ty
Re: Stored Procedures [message #168270 is a reply to message #168135] Wed, 07 June 2006 15:56 Go to previous messageGo to next message
Eclipse UserFriend
is
{call MyStoredProcedure(?,?,?,?)}

have fun
Re: Stored Procedures [message #168304 is a reply to message #168270] Wed, 07 June 2006 17:30 Go to previous messageGo to next message
Eclipse UserFriend
Christian,
Thank you for the reply. However, when I attempt to execute the
following, it always tells me "The value is not set for the parameter
number 1." Debugging in the source, I see that none of my parameters are
bound.
What am I doing wrong? Here's the relevant info from my .rptdesign file.

Thank you!
Ty


<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Claim Data Set" id="6">
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">START_CLAIM_IID</property>
<property name="dataType">string</property>
<property name="position">1</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_CLAIM_IID</property>
<property name="dataType">string</property>
<property name="position">2</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property
name="name">START_SYSTEM_ENTRY_DATE</property>
<property name="dataType">string</property>
<property name="position">3</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_SYSTEM_ENTRY_DATE</property>
<property name="dataType">string</property>
<property name="position">4</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property
name="name">START_SERVICE_START_DATE</property>
<property name="dataType">string</property>
<property name="position">5</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_SERVICE_START_DATE</property>
<property name="dataType">string</property>
<property name="position">6</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">START_BATCH_EID</property>
<property name="dataType">string</property>
<property name="position">7</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_BATCH_EID</property>
<property name="dataType">string</property>
<property name="position">8</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">START_PRACTITIONER_EID</property>
<property name="dataType">string</property>
<property name="position">9</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_PRACTITIONER_EID</property>
<property name="dataType">string</property>
<property name="position">10</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property
name="name">START_MEDICAL_RECORD_NUMBER</property>
<property name="dataType">string</property>
<property name="position">11</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property
name="name">END_MEDICAL_RECORD_NUMBER</property>
<property name="dataType">string</property>
<property name="position">12</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">START_DIAGNOSIS_CODE</property>
<property name="dataType">string</property>
<property name="position">13</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_DIAGNOSIS_CODE</property>
<property name="dataType">string</property>
<property name="position">14</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">START_PROCEDURE_CODE</property>
<property name="dataType">string</property>
<property name="position">15</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">END_PROCEDURE_CODE</property>
<property name="dataType">string</property>
<property name="position">16</property>
<expression name="defaultValue"></expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<property name="queryText">
{call dbo.PROC_WORKSHEET_REPORT( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ? )}
</property>
</oda-data-set>
Re: Stored Procedures [message #168374 is a reply to message #168304] Wed, 07 June 2006 21:06 Go to previous message
Eclipse UserFriend
In the Data Set Editor you will need to go the the "Parameters" tab and
assig each input parameter a default value. Use "" for empty string.

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Tyrone Hed" <tyronehed@earthlink.net> wrote in message
news:c91fe073938f93ede6b63d386f593b36$1@www.eclipse.org...
> Christian,
> Thank you for the reply. However, when I attempt to execute the
> following, it always tells me "The value is not set for the parameter
> number 1." Debugging in the source, I see that none of my parameters are
> bound.
> What am I doing wrong? Here's the relevant info from my .rptdesign
file.
>
> Thank you!
> Ty
>
>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Claim Data Set" id="6">
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">START_CLAIM_IID</property>
> <property name="dataType">string</property>
> <property name="position">1</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_CLAIM_IID</property>
> <property name="dataType">string</property>
> <property name="position">2</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
> name="name">START_SYSTEM_ENTRY_DATE</property>
> <property name="dataType">string</property>
> <property name="position">3</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_SYSTEM_ENTRY_DATE</property>
> <property name="dataType">string</property>
> <property name="position">4</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
> name="name">START_SERVICE_START_DATE</property>
> <property name="dataType">string</property>
> <property name="position">5</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
name="name">END_SERVICE_START_DATE</property>
> <property name="dataType">string</property>
> <property name="position">6</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">START_BATCH_EID</property>
> <property name="dataType">string</property>
> <property name="position">7</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_BATCH_EID</property>
> <property name="dataType">string</property>
> <property name="position">8</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
name="name">START_PRACTITIONER_EID</property>
> <property name="dataType">string</property>
> <property name="position">9</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_PRACTITIONER_EID</property>
> <property name="dataType">string</property>
> <property name="position">10</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
> name="name">START_MEDICAL_RECORD_NUMBER</property>
> <property name="dataType">string</property>
> <property name="position">11</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property
> name="name">END_MEDICAL_RECORD_NUMBER</property>
> <property name="dataType">string</property>
> <property name="position">12</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">START_DIAGNOSIS_CODE</property>
> <property name="dataType">string</property>
> <property name="position">13</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_DIAGNOSIS_CODE</property>
> <property name="dataType">string</property>
> <property name="position">14</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">START_PROCEDURE_CODE</property>
> <property name="dataType">string</property>
> <property name="position">15</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">END_PROCEDURE_CODE</property>
> <property name="dataType">string</property>
> <property name="position">16</property>
> <expression name="defaultValue"></expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <property name="queryText">
> {call dbo.PROC_WORKSHEET_REPORT( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ? )}
> </property>
> </oda-data-set>
>
Previous Topic:Page Break problem on frameset 2.1-0RC4?
Next Topic:HELP : Add text multiline to the report
Goto Forum:
  


Current Time: Sun Nov 09 17:19:33 EST 2025

Powered by FUDForum. Page generated in 0.03680 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly