Jump to content
Changes to the Jaspersoft community edition download ×

how to implement oracle stored procedure


ktrinad

Recommended Posts

By: mozart - mozart_sk8

how to implement oracle stored procedure

2004-11-28 23:42

good afternoon,

 

I'm having problems when trying to call the oracle stored procedure when I tried to implement it I alwarys received a malformed and the procedure is undefined. How ever when I tried implementing it under the ms sql I haven't encountered any problems at all.

this is how I implement my stored procedure inside the xml document

 

<queryString>{call crm_inv_rpt_postpaid_pkg.crm_inv_rpt_query_sold( '$P!{SLOC_CODE}','$P!{ITEM_CODE}','$P!{INSOLD}')}</queryString>

 

or

 

<queryString>exec crm_inv_rpt_postpaid_pkg.crm_inv_rpt_query_sold( '$P!{SLOC_CODE}','$P!{ITEM_CODE}','$P!{INSOLD}')</queryString>

 

 

Am I in the right track I tried to browse the previous discussions in the forum but still I've encountered the same error. I would really appreciate if someone could help me

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...