Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

execute immediate into [vars]

estroseestrose Member Posts: 32
Can i return with "execute immediate" more than one column value into my variable?

Comments

  • infidelinfidel Member Posts: 2,900
    : Can i return with "execute immediate" more than one column value into my variable?

    Only if your variable is a record type with the same number (and type, I believe) of values that the statement is returning. Or, just use multiple variables.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.