your error message refers to vQUARTER, which isn't listed in your code sample.
also, quarter is 2 characters as defined in your code, but you're asking to put 6 characters into it, e.g. 2016-1
Hi you're right Jeff,
I changed the data type and size and it worked, transitioning from T-SQL still figuring things out:
select to_char(sysdate, 'YYYY-Q') into vQuarter from dual;
This space/forum is for tooling - so if you had a question about SQL Developer itself, like how to access query history - this is the place.
If you have any questions about how to do things you're used to doing in SSMS, then please let us know.