[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] using a user defined pl/sql function
- Subject: [sqr-users] using a user defined pl/sql function
- From: <R.Kaushik@iflexsolutions.com>
- Date: Fri, 24 Nov 2006 17:09:42 +0530
- Delivery-date: Fri, 24 Nov 2006 06:44:25 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AccPvTt0luL1rAhBQsGJMOG8XqQ31w==
- Thread-topic: using a user defined pl/sql function
Hi all,
I am trying to use a user defined function to return a value
Select ud_getparent('PROJECT','DIVISION') from dual
Returns the division for the project.
This works fine as a adhoc sql.
Begin-select
...
.
...
...
...
....
ud_getparent(&PROJECT,'DIVISION') &DIVISION
show &DIVISION
from
...
...
Where
..
...
..
End-procedure
This doesn't work.doesnt give any error. Returns a null though a return
value is available.
Any help ?
Database: Oracle 9i2
SQR: SQR for Peoplesoft.
Thanks & Regards.
Kaushik
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users