| call a function from report. [message #240016] |
Wed, 23 May 2007 22:04  |
nguyenthiphan
Messages: 2
Registered: May 2007
|
Junior Member |
|
|
I'm using Oracle10g in my job,
I created a function with pipelined keyword and parameter in.
When I called the function from report by select SQL or PL/SQL by pass direct parameter such as:
select * from table(tao_bckqdd('1-Mar-2007','%','%'));
--tao_bckqdd is name of function
everything seems ok.
But When i called the function from report by pass parameter by using user parameter of report I got error!!!!!!!
select * from table(tao_bckqdd(:ngaysl,:dkbc,:macn));
Error ORA-22905 cannot access rows from a non-nested table item.
Can everybody help me!!!!!!!!!!!!!!! to call a function from report.
Thanks so much.
|
|
|
|
| Re: call a function from report. [message #240033 is a reply to message #240016] |
Thu, 24 May 2007 00:08  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
This is what Oracle says:| Quote: | ORA-22905: cannot access rows from a non-nested table item
Cause: attempt to access rows of an item whose type is not known at parse time or that is not of a nested table type
Action: use CAST to cast the item to a nested table type
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
