User bio
404 bio not found
Member since Nov 8, 2016

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.

Rajath has no followers yet.
Rajath has not followed anybody yet.
Global Masters badges:
Rajath has no Global Masters badges yet.