| table function in anather function [message #190367] |
Wed, 30 August 2006 06:50  |
unikat
Messages: 2
Registered: August 2006
|
Junior Member |
|
|
Hi
I'v got a problem:
I heve one function like this:
FUNCTION TEST1 (AA IN INTEGER)
RETURN TYPE_TABLE PIPELINED
AS
BEGIN
FOR REC IN (SELECT A, B, C FROM A_TABLE
WHERE D = AA)
LOOP
PIPE ROW(TYPE_ROW(REC.A, REC.B, REC.C));
END LOOP;
END;
And the seckend function like this:
FUNCTION TEST2 (BB IN INTEGER)
RETURN TYPE_TABLE2 PIPELINED
AS
BEGIN
FOR REC IN (SELECT A, B, C FROM TABLE(TEST1(BB))
LOOP
PIPE ROW(TYPE_ROW2(REC.A, REC.B, REC.C));
END LOOP;
END;
it does'nt work
please help
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
