Limit portion of bulk collect not compiling


In PL/SQL this compiles

select unique t1.id bulk collect into v2
 from table t1, table t2
 where t2.id(+) =  t1.id and t2.id is null;

but adding a limit statement (as shown below) produces an error (also shown below)

select unique t1.id bulk collect into v2
 from table t1, table t2
 where t2.id(+) =  t1.id and t2.id is null limit 1000;

error
PL//SQL ORA-00933: SQL command not properly ended.

I have moved the "limit 1000" all over the statement trying to get it to compile. No luck. Any ideas?
Patrick_in_MDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

enachemcCommented:
because you are mixing oracle and mysql

bulk collect is oracle
limit is MySQL syntax not supported by oracle
morguloCommented:
Try "rownum<=..." instead of limit.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
>>limit is MySQL syntax not supported by oracle

You sure about that?  You just need to use FETCH and a cursor.

http://download.oracle.com/docs/cd/B12037_01/appdev.101/b10807/12_tune.htm#i48876

Limiting the Rows for a Bulk FETCH Operation with the LIMIT Clause

The optional LIMIT clause, allowed only in bulk FETCH statements, limits the number of rows fetched from the database.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.