Re: Passing retrieval arguments to DW stored procedure

Thanks, Bruce. I'll create the wrapper procedure.

The only inconsistency I see is "why did the datawindow successfully execute the procedure without retrieval arguments". When the execution call from PB was simply "execute db_owner.my_pack.my_proc;0" it worked like a champ.

Brian in Seattle

In article <6rrsv0$pup$1_at_nnrp1.dejanews.com>,   Bruce Armstrong [TeamPS] <bruce.armstrong_at_eudoramail.com> wrote:
> You can't call a procedure within a package directly from a datawindow. What
> you need to do is write a 'wrapper' stand-alone procedure that calls the one
> in the package. You then call that from the datawindow.
>
> In article <6rl2g6$rnf$1_at_nnrp1.dejanews.com>,
> vick9935_at_my-dejanews.com wrote:
> > I am getting an ORA-20004 "Syntax error attempting to parse..." when passing
 a
> > retrieval argument to an Oracle stored procedure.
> >
> > My "execute" statement is the following:
> >
> > execute dbowner.my_pack.my_proc(:as_user);0
> >
> > This same datawindow can successfully execute the stored procedure when I do
> > not pass a retrieval argument (hardwiring the value into the stored
 procedure
> > SQL). My procedure declaration, within my package body, includes the
> > following:
> >
> > procedure my_proc (avc_user in varchar2,rc in out rc_type ) as
> > begin
> > OPEN rc FOR SELECT ROUND((SUM(NVL((CURRENT_BUDGET_PROJ *
> > PCT_TASK_BUDGET)/100,0)))/1000,0) MonthDollar,
> > .
> > .
> > .
> > WHERE USERID = avc_user
> > .
> > .
> > .
> >
> > Any ideas would be greatly appreciated,
> >
> > --
> > Brian in Seattle
> >
> > A person who smiles in the face of adversity...probably has a scapegoat.
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
>
> --
> Bruce Armstrong [TeamPS]
> Preach the gospel at all times.
> If necessary, use words.[Francis of Assisi]
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

--
Brian in Seattle

A person who smiles in the face of adversity...probably has a scapegoat.

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum