On Jun 17, 12:04 pm, Michael Moore <michaeljmo...@gmail.com> wrote:
> begin
> execute immediate 'BEGIN
> dbms_output.put_line(''Argh too'');
> end;';
> end;
>
> Not for stored procedures? I must not be understanding what you meant David.
> Mike
>
>
>
> On Tue, Jun 16, 2009 at 1:08 PM, ddf <orat...@msn.com> wrote:
>
> > On Jun 16, 2:04 pm, Vlad <vladimir.mcbad...@gmail.com> wrote:
> > > Can someone show me how you would call a stored procedure (SPB) from
> > > another one (SPA)?
>
> > > SPB can take a variable - a date value. I have been trying with
> > > execute immediate but to no avail.
>
> > > Any pointers would be great.
>
> > Execute immediate is for SQL strings, not stored procedures:
>
> > SQL> create or replace procedure procb(ipar in varchar2) as
> > 2 begin
> > 3 dbms_output.put_line(ipar);
> > 4 end;
> > 5 /
>
> > Procedure created.
>
> > SQL>
> > SQL> create or replace procedure proca (inpar in varchar2) as
> > 2 begin
> > 3 procb(inpar);
> > 4 end;
> > 5 /
>
> > Procedure created.
>
> > SQL> set serveroutput on size 1000000
> > SQL> exec proca('Yarg')
> > Yarg
>
> > PL/SQL procedure successfully completed.
>
> > SQL>
>
> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
Because that isn't what he was attempting:
create or replace proca(inpar in varchar2)
is
begin
execute immediate procb(inpar);
end;
/
which doesn't work. Your correct use of execute immediate does not
call a stored procedure but an anonymous block of PL/SQL code. Vlad
was attempting to use execute immediate to run a previously created
stored procedure.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
