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!

How can you check if user defined table is empty?

2728664Aug 7 2014 — edited Aug 7 2014

Hi, first post here.

I have a small anonymous block which I'm trying to run however it fails with the error 'line 35: not enough values'

The code section is:

code snippet.png

The code fails at the INSERT INTO line.

Any suggestions?

Thanks, Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2014

Added on Aug 7 2014

#cursor

8 comments

505 views