| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> "Connect by" can't be put in Function?
I created a table and used this for querying very well:
select filename from docindex
start with refno = 42
connect by prior parentnode = refno;
But I failed to create this Function object:
create or replace function GetFullPath(pDocIndexRefNo DocIndex.RefNo%type)
return varchar
as
begin
select filename from docindex
start with refno = 42
connect by prior parentnode = refno;
return 'Hello';
end;
Just a simple function, where are my wrong?
-- Best regards, Diviner.Received on Fri Jan 19 2001 - 07:01:21 CST
![]() |
![]() |