Home » SQL & PL/SQL » SQL & PL/SQL » Call procedure
Call procedure [message #200053] Fri, 27 October 2006 12:24 Go to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

How to call a procedure using CALL statement.
I know we can call from execute.
please let me know how to use CALL to run the procedure.


Thanks,
Srinivas


Re: Call procedure [message #200067 is a reply to message #200053] Fri, 27 October 2006 14:01 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Oct 27 12:00:32 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production

SQL> set serveroutput on
SQL> exec dbms_output.put_line('hello1');
hello1

PL/SQL procedure successfully completed.

SQL> call dbms_output.put_line('hello2');
hello2

Call completed.

SQL> 
Re: Call procedure [message #203293 is a reply to message #200053] Tue, 14 November 2006 12:05 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Thanks but its not working in oracle 10g shou;ld i configure anything
Re: Call procedure [message #203302 is a reply to message #203293] Tue, 14 November 2006 12:25 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does it mean, "it is not working"? Did you get an error? If so, which one?

Because, it works on my Oracle 10g:
SQL> select * From v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> set serveroutput on
SQL> exec dbms_output.put_line('hello1');
hello1

PL/SQL procedure successfully completed.

SQL> call dbms_output.put_line('hello2');
hello2

Call completed.

SQL>
Previous Topic: last record in a table
Next Topic: See the sql behind the view
Goto Forum:
  


Current Time: Sat Dec 03 18:15:22 CST 2016

Total time taken to generate the page: 0.03825 seconds