SELECT * from (stored procedure)
Hi all,
If I have a stored procedure returning a select result, for example:
CREATE PROCEDURE sp_test
BEGIN
SELECT * FROM TestTable;
END
And in other stored procedure, I want to use the result, something like this:
CREATE PROCEDURE sp_test
BEGIN
DECLARE MyVar bigint;
SELECT Field1 INTO MyVar FROM sp_test;
END
Is making a code something like above possible?
Thanks in advance.
Subject
Views
Written By
Posted
SELECT * from (stored procedure)
10892
September 14, 2008 01:01AM
4467
September 14, 2008 02:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.