Home » SQL & PL/SQL » SQL & PL/SQL » Calling a procedure inside a procedure [SOLVED]
Calling a procedure inside a procedure [SOLVED] [message #198459] Tue, 17 October 2006 04:41 Go to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Hello is it possible to call a procedure from inside an other procedure?

Kr
Karel

[Updated on: Tue, 17 October 2006 08:12]

Report message to a moderator

Re: Calling a procedure inside a procedure [message #198466 is a reply to message #198459] Tue, 17 October 2006 04:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Yes.
Re: Calling a procedure inside a procedure [message #198481 is a reply to message #198466] Tue, 17 October 2006 06:04 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
JRowbottom wrote on Tue, 17 October 2006 11:47
Yes.



how?

I tryed execute immediate but that didn't work, and aso normal exec..but still nothing.

this is my last attempt:

exec moni.mail@moni.domain.net('parm1','2','parm3', '4');
Re: Calling a procedure inside a procedure [message #198495 is a reply to message #198481] Tue, 17 October 2006 07:03 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You just call the procedure. No need to do anything tricky.
SQL> create or replace procedure t_2 as
  2  begin
  3    null;
  4  end t_2;
  5  /

Procedure created.

SQL> create or replace procedure t_1 as
  2  begin
  3    -- call procedure t_2
  4    t_2;
  5  end t_1;
  6  /

Procedure created.
Re: Calling a procedure inside a procedure [message #198515 is a reply to message #198459] Tue, 17 October 2006 08:12 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
sorry for the stupid question Embarassed , I'm pretty new at pl/sql. My bad, but thx!

Kr
Karel
Previous Topic: CSV file data into Oracle Table Using PL/SQL
Next Topic: ORA-00036: maximum number of recursive SQL levels (50) exceeded
Goto Forum:
  


Current Time: Wed Dec 07 06:47:04 CST 2016

Total time taken to generate the page: 0.11846 seconds