Home » forums » SCT Banner Integration

GORRSQL - Validate Button

Submitted by yeah on Fri, 2010-01-08 13:04

Adding a new role and my SQL performs great in Toad, but when I put it into GORRSQL and press the validate button, nothing happens (it will accept other sql though).

Somehow it doesn't like the sql, any idea on how I can get an error message so that I can actually see what it isn't liking?

thanks

‹ Making a JMS connection to LMG/LMB Are You Using Third Party ID for Luminis Authentication? ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Scroll Down

Submitted by tausalic on Fri, 2010-01-08 15:15.

I've had this happen.  I had to scroll down on the Banner form to see the error message.  Make sure you don't have the semi-colon at the end of the sql statement.  It doesn't like that. 

Alicia

wow, that simple eh?

Submitted by yeah on Fri, 2010-01-08 15:47.

thanks.  just expanded the size of the window -- it is a lot more obvious now.

Syndicate content