Re: Package Status?

Hi,

1. Package header holds the declaration part. If this is error free the status of the package header is "VALID". The package body holds the "coded" part and if it's not error free its status is "INVALID". Recompile package body, issue SHOW ERRORS or SELECT * FROM USER_ERRORS to see compilation errors.
2. SELECT owner.package.function () function_result from dual;

check wether the rights granted allow you to execute funtion.

Scott C. schrieb:
>
> I've written my 1st PL-SQL package - the source of which I ported from MS
> SQL Server - and it seems to compile (at least I don't get any more errors
> after supplying all the necessary semi-colons, replacing the + operator from
> the original Transact-SQL code with the PLSQL '||' concat operator and whole
> mess of other stuff.
>
> Now I have 2 questions:
>
> 1. My GUI administrator (DBArtisan) reports the Package header status as
> "VALID" but the Package Body status as "INVALID". What does this mean?
>
> 2. How do I call a function in my package (from the command line)? I
> tried the obvious: exec owner.package.function () but got an invalid SQL
> error.

--

Regards

Matthias Gresz :-)

--
GreMa_at_t-online.de

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\