[sqr-users] Connect by clause problem

["Ray, Christine Marie" <chmray@indiana.edu>]

I have some sqr code that works in one environment but will not compile
to run from the UNIX command line.

 

Any ideas? No one in my organization has any ideas.

 

begin-program

columns 2 7 12 17 22 27 32 37 42 47

do get_input

do main 

end-program

 

begin-procedure main

begin-select

level &level 

            Move &level to #level 

            use-column #level

            Print #level (+1) edit 888

!lpad(level,2*level -1)||' '|| 

ro_tree_entry_lbl &label (, +2)  

ro_childobjtyp_cd                               &child (, +2) 

from dss.ie_mstr_cat_alph_v 

start with ro_tree_entry_lbl like [$folder]

connect by prior ro_child_tech_nm = ro_parnt_tech_nm

end-select

end-procedure ! main

 

begin-procedure get_input

Input $folder

Let $folder = '''' || $folder || ''''

end-procedure ! get_input

 

ERROR message:

 

Hyperion SQR Server 8.3.1

Copyright (c) 1994-2005 Hyperion Solutions Corporation.  All Rights
Reserved.

 

(SQR 5528) ORACLE OCIStmtExecute error 1788 in cursor 1:

   ORA-01788: CONNECT BY clause required in this query block

SQL:  SELECT level, ro_tree_entry_lbl, ro_childobjtyp_cd  from

      dss.ie_mstr_cat_alph_v

 

Error on line 28:

   (SQR 3716) Error in SQL statement.

 

 

Errors were found in the program file.

 

SQR: Program Aborting.

 

 

 

 

 

 

 

Christine Ray

Indiana University Bloomington

FMS Administration

Poplars 833

 

812-856-2411

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users