how to implement oracle stored procedure

[ktrinad]

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