Re: syntax - query's scalar results to a varible?

oh, ive also discovered Oracle SQL*Plus, and am learning how to use a command-line console. in sql*plus, i see that the lines:

    SET serveroutput ON;
    exec dbms_output.enable;

..work w/o errors. as does DECLAREing the variable, and SELECTing a
value into. now the only thing that doesnt work is the line:

    dbms_output.put_line(v_roleID);

...(w/o the BEGIN/END; it didnt like those so i omitted them)

i may be getting closer.

matt Received on Fri Jul 07 2006 - 14:08:46 CDT