Re: [sqr-users] Connect by clause problem

["Mike Eischen" <MEISCHEN@genesco.com>]

I've run into situations where there was a problem with an SQL statement
in my SQR code, but the SQL did not execute. For example, there was an
if-then clause in the program, and the conditions were never met, so the SQL
was never executed.  I ran the SQR from my PC and had no problems, but
when I ran the same SQR in UNIX, I received an Oracle error. Apparently the 
error checking is more robust when you run an SQR in a UNIX environment. 
Try executing just your SQL statement to make sure it is not the source of 
the problem.  I hope that helps. 
 

>>> chmray@indiana.edu 11/18/05 3:40 PM >>>
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


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