OraFAQ Forum: SQL & PL/SQL » pl/sql very urgent

Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql very urgent

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

pl/sql very urgent [message #41140]

Fri, 29 November 2002 05:15

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

Hi everybody

if i create a procedure like

declare
a number;
begin
select sal into a from emp where empno=7788;
dbms_output.put_line(a);
end;

Please tell me where this procedure code store in database. I query user_source but it did't show me the code.
Thanks
and how to query this.

Report message to a moderator

Re: pl/sql very urgent [message #41141 is a reply to message #41140]

Fri, 29 November 2002 05:49

Viswa
Messages: 8
Registered: October 2002

Junior Member

Hi Tom,

What you have written is not a procedure. It is a PL/SQL block it will not not be stored in the database. Only the stored procedure will be stored in the database.

Regards
Viswa

Report message to a moderator

Re: pl/sql very urgent [message #41155 is a reply to message #41140]

Mon, 02 December 2002 16:41

Darryl D'souza
Messages: 2
Registered: December 2002

Junior Member

That' an anonymous pl/sql block ....it is not stored anywhere.

Darryl

Report message to a moderator

Re: pl/sql very urgent [message #41157 is a reply to message #41140]

Mon, 02 December 2002 20:25

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

In order to create a procedure that is stored in the database and can be viewed by selecting from user_source, you need to use the syntax CREATE OR REPLACE PROCEDURE and give it a name, like:

CREATE OR REPLACE PROCEDURE procedure_name
AS
  a NUMBER;
BEGIN
  SELECT sal 
  INTO   a 
  FROM   emp 
  WHERE  empno = 7788;
  DBMS_OUTPUT.PUT_LINE (a);
END procedure_name;
/

Report message to a moderator

Previous Topic:	sql join question
Next Topic:	functions and procedures.....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 07:06:56 CDT 2024