Query works but not in package
Hi,
I have this query that executes fine if I put it in a sql editor, I get a nice result set. However, when i put it in a procedure (in a package) I get the following error:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current ex
Why is this? The procedure uses querys from another schema, but since it works in sql editor?...
I have granted selects on all the tables in used by the SP.
Anyone?