Forum Stats

  • 3,838,112 Users
  • 2,262,333 Discussions
  • 7,900,511 Comments

Discussions

Select and Where with Items without submit...

tdobe
tdobe Member Posts: 183 Blue Ribbon
edited Jun 8, 2019 3:16AM in APEX Discussions

Hi,

Is it possible to provide a parameter to the source, which is item, but without submitting its value?

select * from table where id =: P1_ID - this is a standard query execution, however it requires that the value be sent to the server. Is it possible to construct a query in such a way that the value can be passed directly to the query and not via sessions?

thx.

Tagged:
Scott Wesley

Answers

  • fac586
    fac586 Senior Technical Architect Member Posts: 21,101 Red Diamond
    edited Jun 8, 2019 3:16AM
    tdobe wrote:Is it possible to provide a parameter to the source, which is item, but without submitting its value?

    select * from table where id =: P1_ID - this is a standard query execution, however it requires that the value be sent to the server. Is it possible to construct a query in such a way that the value can be passed directly to the query and not via sessions?

    Possibly, but it would be more complex than using APEX session state. There is obviously no way to do so without making some kind of request to the server.

    What problem are you really trying to solve? Where, when, and how is the query used?

    tdobeScott Wesley