Home » SQL & PL/SQL » SQL & PL/SQL » How we will call another procedure within procedure??
How we will call another procedure within procedure?? [message #219961] Sat, 17 February 2007 00:33 Go to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

How we will call another procedure or (function)
within procedure or (function)???
Re: How we will call another procedure within procedure?? [message #219963 is a reply to message #219961] Sat, 17 February 2007 00:37 Go to previous messageGo to next message
BlackSwan
Messages: 25045
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
Re: How we will call another procedure within procedure?? [message #219983 is a reply to message #219961] Sat, 17 February 2007 04:56 Go to previous message
William Robertson
Messages: 1640
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.

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


Current Time: Wed Dec 07 20:50:06 CST 2016

Total time taken to generate the page: 0.16160 seconds