Getting error in Drop command in sql

SarthakJain · 09-22-2022, 05:26 AM

Code:

CREATE OR REPLACE PACKAGE Students2 AS
  PROCEDURE proce(f_name varchar2, l_name varchar2);
END;

CREATE OR REPLACE PACKAGE BODY Students2 AS
  PROCEDURE proce(f_name varchar2, l_name varchar2) IS
  BEGIN
   INSERT INTO Stu2(f_name, l_name) VALUES(f_name, l_name);
  END;
END Students2;

BEGIN
  Students2.proce('bat', 'man');
END;

this code runs accurately and batman gets embedded in the table which I made.

in any case, with regards to dropping the bundle

Code:

DROP PACKAGE Students2;

it gives this error;

SQL Error [933] [42000]: ORA-00933: SQL command not properly ended

What could I be missing? Can anybody suggest with a solution as I already tried researching on google and read many articles like on the [link moderated] etc.

Thanks in Advance!

NevemTeve · 09-22-2022, 05:45 AM

Did you try it with Sql*Plus?

pan64 · 09-22-2022, 06:12 AM

probably helps: https://www.tekstream.com/resource-c...roperly-ended/

TB0ne · 09-22-2022, 08:28 AM

Quote:

Originally Posted by SarthakJain

Code:

CREATE OR REPLACE PACKAGE Students2 AS
  PROCEDURE proce(f_name varchar2, l_name varchar2);
END;

CREATE OR REPLACE PACKAGE BODY Students2 AS
  PROCEDURE proce(f_name varchar2, l_name varchar2) IS
  BEGIN
   INSERT INTO Stu2(f_name, l_name) VALUES(f_name, l_name);
  END;
END Students2;

BEGIN
  Students2.proce('bat', 'man');
END;

this code runs accurately and batman gets embedded in the table which I made. in any case, with regards to dropping the bundle

Code:

DROP PACKAGE Students2;

it gives this error; SQL Error [933] [42000]: ORA-00933: SQL command not properly ended

What could I be missing? Can anybody suggest with a solution as I already tried researching on google and read many articles like on the [link moderated] etc.

Your profile says that you're a computer-science and engineering graduate...but this is very obviously a homework question. And you are posting no details at all, such as what database (assuming Oracle), on what platform, and the context of what you're doing. Is this a stored procedure/function?? Where does the drop package statement come into play, since it's not in the 'code' you posted initially??

Ask a clear question and explain what you're trying to do, because all we can tell you now is exactly what you can look up for that error message; and I would suggest you look at what you posted, and think about it.

NevemTeve · 09-22-2022, 10:43 AM

In some contexts, simple SQL statements aren't terminated with ';'semicolon, but PL/SQL blocks are.
In other contexts (e.g. Sql*Plus) ';'semicolon is always used, but PL/SQL blocks are to be terminated with a '/'slash e.g.

Code:

BEGIN
dbms_output.put_line('Hi');
END;
/

grail · 09-25-2022, 01:44 AM

May we confirm that you have logged in to a fresh connection and only typed the drop command?

Did you type it or copy it?

Are you logged in to an appropriate schema to be able to drop it?

Also, not sure why you would provide a link to "drop table" when you are trying to drop a package?

dugan · 10-18-2022, 02:48 PM

Sorry, just LOL’ing at the Wikipedia link. Seriously: if you haven’t clicked it, do so.

grail · 10-18-2022, 10:31 PM

Quote:

Originally Posted by dugan

Sorry, just LOL’ing at the Wikipedia link. Seriously: if you haven’t clicked it, do so.

Yep ... that is funny

dugan · 10-19-2022, 01:34 PM

Reposting the Wikipedia link that got moderated:

https://en.wikipedia.org/wiki/Drop_table