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>
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 StudiosReceived on Thu Aug 28 2008 - 14:00:53 CDT