#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0

    Unknown token 'into' when using EXECUTE STATEMENT


    I use EXECUTE STATEMENT to return values from select like this:

    Code:
    EXECUTE STATEMENT 'select '||:fl||','||:f2||','||:f3||
          ' from tab1 where tab1_ID = '||:f_id
          into :v_f1,:v_f2,:v_f3;
    when I try to execute I get unknown token 'into' why is that and how to solve ?

    thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0
    the situation was very silly the transaction was still active so any changes to SP codes was not seen once I modified my SP and reconnect again the SP work without problems

    thanks for the help

IMN logo majestic logo threadwatch logo seochat tools logo