Newbie: how to dynamically add layer from oracle

steveevans

Total newbie here.

    I have an asp .net (web) application that dynamically creates a new oracle table during a users session (table name is radomly generated).
   
    This table has 3 columns: UniqueId, X_coord, Y_coord.
   
    I need to change this app so that it can plot these points on a map

    What is the best way of doing this within the javascript api (presuming javascript api is the way to go).

    BTW, we have arcgis 10.1 server and desktop.

    Thanks a whole lot in advance.

    Steve

derekswingley1

You'll need to publish your table via ArcGIS Server to use it in a JavaScript API app. Since your table is generated per user session, I don't think there's a clean way to do this. Could you modify your architecture to always have a single table that has a user_id column and then filter records from the table based on a user_id? You could then have a process that periodically cleans up your table so it doesn't grow indefinitely.

Alternatively, if you know the name of the per-session table, and it's published as a web service, you could use esri.request to send a request to your web service to get your points.