User Profile

Collapse

Profile Sidebar

Collapse
archna1
archna1
Last Activity: Mar 25 '08, 07:03 PM
Joined: Mar 18 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • archna1
    replied to Dynamic sql generation using oracle 10g stored procedures
    in Oracle
    My input parameter is comma separated values to search within a table, hence I needed dynamic sql and the 'IN' clause. It is part of a 'Search' function I am building for an intranet, so I needed all the values entered by the user for Search--

    I tried this code and unexpectedly it worked..
    [code=oracle]

    (
    V_Search_Key in varchar2,
    P_LinkSearchRes ults_CUR out sys_refcursor
    )
    as
    begin...
    See more | Go to post
    Last edited by amitpatel66; Mar 20 '08, 03:33 PM. Reason: code tags

      Leave a comment:

    • archna1
      started a topic Dynamic sql generation using oracle 10g stored procedures
      in Oracle

      Dynamic sql generation using oracle 10g stored procedures

      Hi,

      I created a stored procedure as --

      [code=oracle]


      (
      V_Search_Key in varchar2,
      P_LinkSearchRes ults_CUR out sys_refcursor
      )
      as
      lv_sql varchar2(1000);
      begin
      lv_sql := 'select b.link_id, b.link_display_ name, b.override_link _display_name, b.link_path
      from oppe_search a, lu_links b
      where a.content_id=b. link_ID and upper(a.search_ key) in (:v_search_key) '...
      See more | Go to post
      Last edited by amitpatel66; Mar 18 '08, 02:43 PM. Reason: code tags
      No activity results to display
      Show More
      Working...