Just moved a version 7.3.3. database to an Oracle 8.1.5 database
with an import. One trigger wouldn't compile in 8.1.5. It turned out
to be a trivial fix, but I was curious about it anyway. It was a
trigger
that called a function that declared the types of the arguments to the
procedure,
like this.
Create or replace trigger xxxxxyyyy
...
begin
aprocedurecall( :col1 in NUMBER,
:col2 in VARCHAR2,
)
Etc.,
Thinking about it, I don't know why those "in NUMBER" etc., were in the
code anyway,
but I just removed them.
Anyone have any observations about this syntax ?
Received on Wed Aug 04 1999 - 08:46:41 CDT
