Re: Package procedure as inline view

From: rios <rios_at_rios.com>
Date: Wed, 10 Jan 2007 13:41:10 -0500
Message-ID: <12qacq74nt8cnce@corp.supernews.com>

yes, but FUNCTIONS not Procedures

Look into
1) Pipeline Functions and
2) Function that return Table of Objects

e.g on (2):

CREATE OR REPLACE TYPE emp_obj IS OBJECT( EMPNO NUMBER,
ENAME VARCHAR2(10),

JOB      VARCHAR2(9),
MGR      NUMBER,
HIREDATE DATE,
SAL      NUMBER,
COMM     NUMBER,

DEPTNO NUMBER); CREATE OR REPLACE TYPE emp_obj_tab IS TABLE OF emp_obj;

FUNCTION earned_premium_schedule
(p_ename emp.ename%type) RETURN emp_obj_tab is
begin

• populate the collection end ;

Received on Wed Jan 10 2007 - 12:41:10 CST