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