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!

ORA-00933: SQL command not properly ended

613024Dec 11 2007 — edited Dec 11 2007
Hi I have an issue When I execute my procedure I have this error
ORA-00933: SQL command not properly ended. But I tried to print the same sql statement and execute and it gives the output.. could some body please help here is my sql script

EXECUTE IMMEDIATE 'SELECT ' ||house_master ||'.addr_zip_5 FROM ' ||
customer_master || ' , ' || house_master || ' , ' || equipment || 'WHERE '|| customer_master || '.site_id='|| house_master || '.site_id AND ' ||
customer_master || '.account_number = ' || equipment || '.account_number AND '||
equipment || '.house_number =' || house_master ||'.house_number AND ' ||
customer_master || '.account_number = ' || accountNumber || ' AND '|| customer_master || '.site_id = ' || siteId INTO zipCode;

could somebody please help me

thanks..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2008
Added on Dec 11 2007
12 comments
2,316 views