This content has been marked as final. Show 3 replies
First of all, remove asterisk sign from the end of line
Second: where you try to put this code? This is not SQL, but PL\SQL so you have to have some variable where you want to put query result like this:
select * from ULQUEUE;*
This of course works when your query returns only one row. Otherwise process data in the loop or put result into array.
declare x ULQUEUE%Rowtype; begin select * into x from ULQUEUE end;