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