Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2001
    Posts
    45

    Unhappy Unanswered: EXECUTE IMMEDIATE won't work at all

    HELP!! This is crazy, at last I found the Oracle-eval() but it just doesnt work!!

    EXECUTE IMMEDIATE 'BEGIN HTP.P("test"); END;';

    Whats wrong with this code???
    Any hints appreciated...
    waldemar

  2. #2
    Join Date
    Dec 2001
    Location
    TX
    Posts
    1

    Post

    I'm not sure exactly what your code means, but I can tell you this...

    If you try to use a query in EXECUTE IMMEDIATE, it can only return one value. It is not quite as simple as an eval() method is in some languages. If your query returns more than one value you have to use PARSE and BIND all variables you are using in the statement.

    Hope that helps, and maybe one of the gurus on this board can expand on that a bit.

    jade

  3. #3
    Join Date
    Nov 2001
    Posts
    45

    Post

    Thanks, I understand this is for queries.

    But I'm using execute immediate with a pl/sql block. In all references I found this code (enclosing in begin/end) to work... I'm puzzled it doesnt on my machine...

  4. #4
    Join Date
    Dec 2001
    Posts
    5

    Re: EXECUTE IMMEDIATE won't work at all

    Originally posted by waldemar
    HELP!! This is crazy, at last I found the Oracle-eval() but it just doesnt work!!

    EXECUTE IMMEDIATE 'BEGIN HTP.P("test"); END;';

    Whats wrong with this code???
    Any hints appreciated...
    waldemar
    ppppp

  5. #5
    Join Date
    Dec 2001
    Posts
    5

    Re: Re: EXECUTE IMMEDIATE won't work at all

    Originally posted by gavin


    ppppp

    pppp

  6. #6
    Join Date
    Dec 2001
    Posts
    5

    Re: Re: Re: EXECUTE IMMEDIATE won't work at all

    Originally posted by gavin



    pppp
    pppp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •