Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Live SQL Worksheet Error That Wont Clear

02372e11-17fb-48ca-88de-e8b8ef873912Nov 21 2019 — edited Nov 22 2019

Hello - Sorry if this is a simple or repeat question but didn't have much luck looking in the FAQs.

When trying to use the Live SQL Worksheet I get an error that says "1 Error has occurred: PL/SQL: Function returned without value". The worksheet is blank and no code is showing. The bottom of the worksheet page says:

"Invalid Expired

Your session has expired due to inactivity or another reason. If you wish to retain your session SQL, you will need to save your work.
Session Status: ""

Two weeks ago, I entered some basic sample code to test things not intending to save the session. There are no database objects. I've tried to reset the session, deleting old sessions, logging in/out but this error still appears. The error prevents me from entering anything into the worksheet. Currently using Chrome to access the web page if that makes a difference. How do I "reset" the worksheet?

Comments
Post Details
Added on Nov 21 2019
2 comments
833 views