Please correct me if i'm wrong ,

Currently i am using the below code to connect to the Oracle Database.  (JDBC Connection)

     Set conn=##class(%SQLGatewayConnection).%New()
    Set sc=conn.Connect("Test_Database","Test_user","testuser",300)
    If $$$ISERR(sc) do $System.Status.DisplayError(sc) quit

When run the application i get the below pop up\

A JavaScript  exception  was caught during the execution of the HyperEvent:

Syntax Error:Unexpected token illegal
​--------------------------------------------------
Result :
-------------------------------------------------
JavaScript Code:
Error #6002:Gateway failed: DSN/User connect
-----------------

I have the Connection configured in Configuration->SQL GatewayConnection which is working absolutely fine.

Please let me know the proper Code and the Syntax to connect to the Oracle DB

I just have to display few values from oracle DB in the UI. I don't have to load the data in the cache DB

currently i am using Oracle 11g. i need to fetch some data from the table to process the data. Hence i would want to connect to the DB from the CSP page.

I just need to know the syntax of retrieving values from the Databse (not cache DB) directly from the CSP page..

Eduardo -
Group By ID is option does not exist in 2010 Ensemble. Is there any other alternative for this ??

Thanks a lot... Seems to work as expected