Print Thread
Compiler-Hints: FUNCTION RETURN PIPELINED
#36607 11/27/09 08:39 AM
Joined: Nov 2004
Posts: 16
M
Member
OP Offline
Member
M
Joined: Nov 2004
Posts: 16
PL/SQL-Developer Version 8.0.0.1480


Hello,

As I define a pipelined-function

CREATE FUNCTION fct_test (...)
RETURN ...
PIPELINED IS
...
BEGIN
...
END fct_test;

to use it in a SELECT-Statement

SELECT .... FROM TABLE(fct_test(...));

the Compiler-Hint "Function '...' does not return a value"
is printed - but there is a return-value!

Can you fix it in the hints please?




Last edited by Marc Bisping; 11/27/09 08:42 AM.
Re: Compiler-Hints: FUNCTION RETURN PIPELINED
Marc Bisping #36610 11/27/09 10:34 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
This is indeed not correct. We'll fix it.


Marco Kalter
Allround Automations
Re: Compiler-Hints: FUNCTION RETURN PIPELINED
Marco Kalter #36612 11/27/09 11:03 AM
Joined: Nov 2004
Posts: 16
M
Member
OP Offline
Member
M
Joined: Nov 2004
Posts: 16
Thank you!

:-)


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.011s) Memory: 2.5018 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-11 17:08:04 UTC
Valid HTML 5 and Valid CSS