Best idiom for looping over input?

From: <mh_at_pixar.com>
Date: Thu, 28 Aug 2008 18:58:34 GMT
Message-ID: <uzCtk.19684$mh5.18411@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 - 13:58:34 CDT

Original text of this message