Package syntax in PLSQL

Question

I found the following code assumed to be PLSQL:

package Z                                                                                                                                                                      

    V_LOT   NUMBER(17,2);                

    ...

end Z;

However, from the oracle documentation, it seems to be that "package" statement needs to have always a "create" before the "package" word.

Is this code correct?

thanks

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

According to documentation the CREATE statement is necessary, so your code is incorrect. It has to be like this:

create package z
is
  V_LOT   NUMBER(17,2);
  ...
end z;

Package syntax in PLSQL

Sign up