# Execute snippet from package results in ora-942

**URL:** <https://forums.toadworld.com/t/execute-snippet-from-package-results-in-ora-942/38176>\
**Category:** Toad for Oracle - Beta\
**Created:** [August 12, 2016, 8:44am UTC](https://forums.toadworld.com/t/execute-snippet-from-package-results-in-ora-942/38176 "2016-08-12T08:44:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\
**Post date:** [August 12, 2016, 8:44am UTC](https://forums.toadworld.com/t/execute-snippet-from-package-results-in-ora-942/38176/1 "2016-08-12T08:44:56Z")

</div>

The snippet has a bunch of WITH clauses.

SELECT \*  
FROM ALL\_LAST\_SALES  
Error: ORA-00942: table or view does not exist

ALL\_LAST\_SALES is a defined within my snippet via a WITH clause, so the error is technically correct, though the SQL is not correct.

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [August 12, 2016, 10:34am UTC](https://forums.toadworld.com/t/execute-snippet-from-package-results-in-ora-942/38176/2 "2016-08-12T10:34:33Z")

</div>

I tried an example based on how I understand the problem and I’m missing something. Execute snippet in this example is working as expected for me. Please provide a sample.

```auto
    DECLARE
n NUMBER;
BEGIN
WITH my_cte_1 AS (SELECT * FROM user_objects),
my_cte_2 AS (SELECT * FROM user_objects)
SELECT COUNT (*)
INTO n
FROM my_cte_1 t1, my_cte_2 t2
WHERE t1.object_id = t2.object_id;
DBMS_OUTPUT.put_line (n);
END;

```