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:
- My GUI administrator (DBArtisan) reports the Package header status as
"VALID" but the Package Body status as "INVALID". What does this mean?
- 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.
Received on Wed Jul 29 1998 - 14:18:13 CDT
