I have used getCannonicalPath() in oracle 9i and the sql query was working.I have run the same query in oracle 10g but it says "SQLException: ORA-00904: "GETCANONICALPATH": invalid identifier"


what is the equivalent function in oracle10g.

thanks in advance

subramanyam