OraFAQ Forum: SQL & PL/SQL » How we will call another procedure within procedure??

Home » SQL & PL/SQL » SQL & PL/SQL » How we will call another procedure within procedure??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How we will call another procedure within procedure?? [message #219961]

Sat, 17 February 2007 00:33

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

How we will call another procedure or (function)
within procedure or (function)???

Report message to a moderator

Re: How we will call another procedure within procedure?? [message #219963 is a reply to message #219961]

Sat, 17 February 2007 00:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Unless you are incapable or unwilling to Read The Fine Manual the answer can be found in
http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

Report message to a moderator

Re: How we will call another procedure within procedure?? [message #219983 is a reply to message #219961]

Sat, 17 February 2007 04:56

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

SQL> CREATE OR REPLACE PROCEDURE testproc
  2  AS
  3  BEGIN
  4      DBMS_OUTPUT.PUT_LINE('Hello, world');
  5  END;
  6  /

Procedure created.

SQL> set serverout on
SQL> exec testproc;
Hello, world

PL/SQL procedure successfully completed.

Report message to a moderator

Previous Topic:	Adding a New Column to an existing non empty table
Next Topic:	NO ROWS SELECTED when using BIND VARIABLE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 03:23:26 CST 2024