I have a question about procedure [message #37216] |
Thu, 24 January 2002 16:08 |
gxg
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Dear sir:
A result can be return from a procedure by a SELECT
sentece in Sbase or SQL Server database. For examle:
CREATE PROCEDURE mytest
AS
SELECT name,age,sex FROM employees
My question is how implement the goal in Oracle
Procedure?
|
|
|
Re: I have a question about procedure [message #37217 is a reply to message #37216] |
Thu, 24 January 2002 18:05 |
sokeh
Messages: 77 Registered: August 2000
|
Member |
|
|
With Oracle, you create variables either as global variables as parameters or local variables to store the select query into.
example:
create or replace PROCEDURE mytest
AS
v_name varchar2(25);
v_age number; -- assuming age is a number datatype
v_sex varchar2(25);
begin
SELECT name,age,sex
into v_name, v_age, v_sex
FROM employees;
end;
these variables are local.
Like I said you could pass them as parameter by
simply including them within the procedure such as
create or replace procedure mytest(v_name out varcahr2,
v_age out number,
v_sex out varchar2)
as
begin
then your select statement
|
|
|
|