0

I wrote a query to insert data to a oracle table in Oracle-SQL Developer.

enter image description here

when Executing SP following error comes. What is the reason?

enter image description here

Improve this question
3
  • That is not a package. It is a procedure. You don't show your pl/sql block, so who knows... Also you should normally not embed a commit in a procedure. Let the caller determine transaction lifetime. Commented Jun 8, 2015 at 14:11
  • No, you are missing semicolons. This did not even compile. Commented Jun 8, 2015 at 14:22
  • 1
    Please don't post code as screenshots. Post code as formatted text Commented Jun 8, 2015 at 14:25

1 Answer 1

Reset to default
1

every statement in sql & plsql should ends with semicolon ; which not exists in insert statement, commit and end commands in your code.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.