using "call" for packaged procedure?

From: <mh_at_pixar.com>
Date: Thu, 28 Aug 2008 19:00:53 GMT
Message-ID: <FBCtk.19685$mh5.12312@nlpi067.nbdc.sbc.com>


After moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure.

Can someone explain why this is?
Many TIA!

old code:

    call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp)

new code (broken):

    call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp)

    ORA-01747: invalid user.table.column,table.column,

               or column specification

new code (works):

    begin p4asset.add(:typename,:repos,:depotFile,:rev); end

--
Mark Harrison
Pixar Animation Studios
Received on Thu Aug 28 2008 - 14:00:53 CDT

Original text of this message