Home » Developer & Programmer » Reports & Discoverer » sys_connect_by_path() not recognized by Reports 9i
sys_connect_by_path() not recognized by Reports 9i [message #113065] Wed, 30 March 2005 17:27 Go to next message
navrsale
Messages: 2
Registered: March 2005
Junior Member
Hi group,

In Reports 9i I created an object level program unit which opens a cursor with SQL query that contains SYS_CONNECT_BY_PATH(...,...) Oracle 9i built-in function.
I get compile error: 'Identifier CONNECT_BY_PATH must be declared).
In SQL*Plus query works no problem?
How should I compile this in Reports 9i?

many thanks,
NM

Report message to a moderator

Re: sys_connect_by_path() not recognized by Reports 9i [message #113161 is a reply to message #113065] Thu, 31 March 2005 04:51 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Tough break. The PL/SQL engine of Reports doesn't know SYS_CONNECT_BY_PATH yet. You could create a database function using this built-in and call your function from reports. An alternative would be dynamic sql.

MHE

Report message to a moderator

Previous Topic: How to change Font and Font size for character mode reports in Oracle Report 6i
Next Topic: Drill Down / Roll Up Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 22:26:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.