Print Page - What is a return type for Oracle stored proc which used to create store proc QS

Title: What is a return type for Oracle stored proc which used to create store proc QS
Post by: NetSpace on 15 Aug 2006 12:30:40 PM

What is a return type for Oracle stored proc which used to createÃ,Â store proc QS?:

types.ref_cursor or
table variable

CREATE OR REPLACE FUNCTION sp_dosomething(list of params)
RETURN types.ref_cursor
AS
....

Are there any other options?

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: NetSpace on 15 Aug 2006 12:30:40 PM