Home » Developer & Programmer » Reports & Discoverer » call a function from report.
call a function from report. [message #240016] Wed, 23 May 2007 22:04 Go to next message
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 Go to previous message
Littlefoot
Messages: 20901
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
Previous Topic: Reports 6.0 runtime (Trying to output to a text file)??
Next Topic: Calling Form from Report
Goto Forum:
  


Current Time: Sat Dec 10 03:01:14 CST 2016

Total time taken to generate the page: 0.05378 seconds