All of the online examples for Oracle Stored Procedures use "SELECT". Perhaps prepending your seventh line with SELECT might return the value?
I'm not familiar with Oracle SPs, so this is complete speculation.
What do you mean?
Something about "SELECT FULLNAME := FIRSTNAME || ' ' || LASTNAME;"?
Can you link me some example?
Thank you very much.
This uses SELECT for returning value from Oracle Stored Procedures:
I've also seen DBMS_OUTPUT.put_line():
I did find one example using the same method as you have used in your example, and cannot understand why it isn't working.
I did also find this blog entry (hope it helps). https://blogs.oracle.com/jdevotnharvest/entry/the_infamous_missing_in_or
UPDATE: In the CF examples of CFSTOREDPROC that I've seen, the variable names were not prepended with a colon.