[sqr-users] Re: Connect by clause problem

[Nathan Stratton Treadway <nathanst@ontko.com>]

On Tue, Nov 22, 2005 at 04:45:27PM -0500, Ray, Christine Marie wrote:
> It is my understanding that the environment that works and the test
> environment are identical.  
> 
> The reason I believe this is a compile time error is that the error is
> displayed before the sqr asks for any parameters.  When I do not include
> the [$folder] in the sql, the sqr asks prompts for the $folder entry.

Yeah, that does sound like a compile time error...

If your original email cut-and-pasted the full sqr program and the full
SQR error message, then it's very puzzling....

Normally if there were a compile time error, I wouldn't expect to see
anything after the "FROM ..." table list passed to the database (since
you have a dynamic variable in the bottom part of the statement.  This
does match the text shown in the SQL: line of your error message... but
in that case Oracle should not be receiving the "START WITH" part of the
SQL statement, and thus it would have no reason to raise an ORA-01788
error.  On the other hand, if the error were occuring at run time, I
would expect to see the "START WITH" text in the SQL: line of the error
message.  (I just ran a couple tests using SQR v8.3.1 Solaris/Oracle to
confirm that this is really what happens with a "start with" SQL
statement in both sitations.)

In your case, you seem to be getting the SQL: text without the "start
with" but an error message that indicates that Oracle did see that
clause somehow....


Removing the dynamic SQL is definitely the best solution in the long
run, but as far as I can see what you used to have "should" work -- or
at least should give a different error message than you are seeing...


                                                        Nathan


----------------------------------------------------------------------------
Nathan Stratton Treadway  -  nathanst@ontko.com  -  Mid-Atlantic region
Ray Ontko & Co.  -  Software consulting services  -   http://www.ontko.com/
 GPG Key: http://www.ontko.com/~nathanst/gpg_key.txt   ID: 1023D/ECFB6239
 Key fingerprint = 6AD8 485E 20B9 5C71 231C  0C32 15F3 ADCD ECFB 6239

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